Heat Map

[mishraamit2485]

Hi All,

I have to create a heat map dashboard the requirement is something like.

if Col A/Col B is +/- 33.3% show same color (lets say Red) for -ve as well as +ve

Col A/Col B is +-20% show same Color (Lets say Light Red )

and so on.

I saw one blog from the great HIC (Colors in charts) and I'm planing to follow his way to create the same

OTHERS WAYS ARE MOST WELCOME

So,.

I have created the inline

Colours:

Load * Inline

[Perc, Red, Green, Blue

10%, 255, 0,0

20%,0,255,0

30%,0,0,255

40%,255,255,255

50%,255,100,200

]

now the issue is how can I create a mapping load statement out of this inline? what should I write in the From part for mapping load.

I do not want to use share point to keep my color codes there i want to keep them in the script.

ColourMapping:

Mapping LOAD

Perc, RGB(Red,Green,Blue) as Colours

From

??????????????

[mishraamit2485]

Any suggestions experts?