Need help in Colormix function

[#1]

Hello Everybody,

I have used colormix function in Grid Chart, put the upper limit, Intermediate limit and lower limit but it's not working I guess.

The colors are same for the entire chart.

Could anyone please help me.

Please find the attached sample.

Thanks in Advance.

Sonali

[jagan]

Hi,

Give this as Background expression

RGB(Mod(FieldIndex('Application Name', [Application Name]) * 80, 255) , Mod(FieldIndex('Application Name', [Application Name]) * 120, 255), Mod(FieldIndex('Application Name', [Application Name]) * 200, 255))

Hope this helps you.

Regards,

jagan.

[#3]

Hi Jagan,

Thanks for your reply.

It's working but what I need is If the Category of the Application is High then the color should dark , if it is Medium the color should lighter and if it is Low then it should be more lighter.

Basically I want the color should be Dark- Lighter-Lighter like we have in Heat Map.

Thanks

Sonali

[jagan · Accepted solution]

Hi,

Try like this

=Pick(Match(Criticality, 'High', 'Medium', 'Low'), RGB(90, 0, 0), RGB(150, 0, 0), RGB(255, 0, 0))

Regards,

Jagan.

[#5]

Hi Jagan,

Thanks for your help. It is working as expected.

One more question I want to ask. Could you please tell me how to change the size means if the criticality is high then the object  should be bigger if it is medium then it should be smaller and if it is Low then it should be smaller.

Thanks

Sonali

[#6]

Hi Jagan,

I have added one more field called score sum(score) is working fine with the size.

Thanks for your help.