Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I have the following expression
=Concat(Customer & ' - ' & Num(Aggr($(e.tickets), Customer), '#,##0'), chr(10), -Aggr($(e.tickets), Customer))
Which returns the correct number of tickets for each Customer, However when I add to a heatmap and hover over the day, it will not display the Qty's for each Customer, any ideas.
if I add the above expression in a text object it works fine
Sounds good
Please the attached file, still early stages, have decided on design yet
Try this
=REPEAT(CHR(13),2) & REPEAT('-',10) & chr(13) & $(e.tickets) & ' Tickets Created' & CHR(13) &
Concat(DISTINCT If(Len(Trim(Aggr($(e.tickets), Customer, Year, Weekday, Week))) > 0, Customer & ' - ') & Num(Aggr($(e.tickets), Customer, Year, Weekday, Week), '#,##0'), chr(10), -Aggr($(e.tickets), Customer, Year, Weekday, Week))
Perfect