Heat Map - mix colors problem

[#1]

Hello,

I have the following heat map please see attached.

Expression which i have is:

count({$<Incoming_Flag = {1}>}TXID)

in background I have the following color mix formula:

ColorMix1( Count ({<Incoming_Flag = {'1'}>} TXID)/(sum(total <Date> aggr(Count ({<Incoming_Flag = {'1'}>} TXID),Day,Hour)))

,rgb(255,255,255),rgb(150,0,0))

So,

why 11 tickets we got on the 13/07/2016 at 1:00 pm are so red, while 25 tickets we got on the 17/07/2016 at 11:00 am are much less red?

Please advise.

Thanks,

Inna

[#2]

Hi,

can anybody help me?

Thanks,

Inna

[sunny_talwar · Accepted solution]

How about if you try this:

ColorMix1(Count ({<Incoming_Flag = {'1'}>} TXID)/(Max(TOTAL <Date> Aggr(Count({<Incoming_Flag = {'1'}>} TXID), Day, Hour))), RGB(255,255,255), RGB(150,0,0))

[#4]

hi,

it helped.

Thanks a lot.

Inna.

[sunny_talwar]

Not a problem