How to use single value tiles for calculation?

Hi
I have a Title with Moth to date spend, another with Days left of the month, and a 3rd one with avg daily spend. How can I use those values into one tile to calculate a projected spend = Month to date spend + (Days left * Avg Daily spend)?

 

0 2 370
2 REPLIES 2

IanT
Participant V

You can’t, got to bash it out in one query.

jcdufault
Participant II

If you can get all 3 elements on the same tile, you could do a table calculation like so:
 

sum(${product.sale_amount})
+(
(sum(${product.sale_amount})/count(${product.sale_amount}))
*
(extract_days(add_days(-1, date(extract_years(add_months(1, now())), extract_months(add_months(1, now())), 1)))-extract_days(now()))
)


then you can hide all the columns except the table calculation and the number would display correctly

Top Labels in this Space
Top Solution Authors