Using Concat Aggr in a Heatmap

[rustyfishbones]

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

[sunny_talwar]

Sounds good

[rustyfishbones]

Please the attached file, still early stages, have decided on design yet

[sunny_talwar · Accepted solution]

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))

[rustyfishbones]

Perfect