Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I have a requirement like to present all risks below 4 score should appear with green color and all to gather in the same place(Not count of risks) means all those should appear 0-4 score rage of X-axis and 5-10 score risks in between 5-10 score and amber color, 10-27 above score red color
I'm partial to colormix2 which will give you a color range for your three sections to show a little more accurately the shift from one area to another. You have to get your values normalized to be from -1 to 1 so I'd recommend this:
Colormix2(((RiskValue * 2) / 20) -1),green() , yellow(), red())
note this assumes your stated range of 0 to 20 being normalized to -1 to 1 and will give you a range or colors. If your users need just three discrete colors you can do if statements thusly:
Colormix2(if(RiskValue<5,-1, if(RiskValue<11,0,1)),green() , yellow(), red())
Based on your stated business requirement a histogram will show a distribution of a single metric. If you'll be doing this for multiple categories you could use a distribution plot.