I want to create a heat map.
i want the colors to change gradually.
I have used colormix wizard but not getting the results properly.
I want the color to change from green to yellow to red for 100% to 0% . But i dont see that smooth change in transition of colors.
I see 58.82% value is red..while i want it to be gradually towards red when it tends to 100%.
My formula is sum of qty for that particular cell by sum of total qty for that date .
(SUM(QTY)/sum(total <Date> QTY))
have attached my qvw. You may add more data to the excel if more data is needed to get the results properly
Any help is appreciated.