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]

If you just use this as your expression... does it show you the numbers?

Num(Aggr($(e.tickets), Customer), '#,##0')

[rustyfishbones]

No i'm afraid not

[sunny_talwar]

What is behind this variable? $(e.tickets)

[rustyfishbones]

COUNT (DISTINCT Ticket_No)

[sunny_talwar]

Does this work?

Num(Aggr(COUNT (DISTINCT Ticket_No), Customer), '#,##0')

[rustyfishbones]

I will try it shortly, just running a reload on another document

[rustyfishbones]

Hi Sunny,

That does not work either, as I said, this works fine in a text object

=Concat(Customer & ' - ' & Num(Aggr($(e.tickets), Customer), '#,##0'), chr(10), -Aggr($(e.tickets), Customer))

but then fails on the heatmap

[sunny_talwar]

May be you need to add Year, WeekDay, Week in your Aggr() function....

=Concat(Customer & ' - ' & Num(Aggr($(e.tickets), Customer), '#,##0'), chr(10), -Aggr($(e.tickets), Customer, Year, WeekDay, Week))

If this doesn't help, would you be able to share a sample?

[rustyfishbones]

I tried that earlier today and it did not return the correct result.

But I will try again, if it does not work I will try share a reduced version of the App.