4 Replies Latest reply: Jul 19, 2016 6:20 AM by Sunny Talwar RSS

    Heat Map - mix colors problem

    Inna Shnaiderman

      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