Heat Map Extension issue

[aniketsr]

Hi Team,

I require a heat map extension objet which works similar to that of pivot table heat map.

Regards,

Aniket

[aniketsr]

any help on pivot chart heat map would also work

[Anonymous]

Hi Aniket,

Usually what I do with a heat make is:

1. Go to expressions

2. create your expresssion that you want to use with your heat map.

3. Once the expression is created, expand the expression and go to background colour.

4. In the Definition for the Background colour, try this formula:

=rgb((rank((set Analysis you want to use),1,1)

            /max(TOTAL aggr(rank((set Analysis you want to use),1,1),<Group By Dimension>))*255),

    255-(rank((set Analysis you want to use),1,1)

            /max(TOTAL aggr(rank((set Analysis you want to use),1,1),<Group By Dimension>))*255),

    0)

[MarcoWedel]

Hi,

maybe this helps:

Sorted Heatmap example

regards

Marco

[ecolomer]

Similar that?

[aniketsr]

Hey Macro,

I have the similar requirement can you please send me the expression or suggest me an extension for the same.

Regards,

Aniket

[aniketsr]

Hey Thabang,

Thanks for the expression but iam getting only green colour in the chart .

Regards

Aniket.

[Anonymous]

Hi Aniket,

You might need to change the formula a bit depending on your requirements.

[Kushal_Chawda · Accepted solution]

Hi,

You can do something like below

Go to your expression-> click on'+' and put below expression in your background colour

Expression:

=colormix1(sum(Amount) / $(=max(aggr(sum(Amount), YourDimension))), white(), Green())

You need to modify your expression as per the need

[MarcoWedel]

Hi,

hope this helps

regards

Marco