Which chart is suitable to present Distribution data across the scoring like 0-4,5-10,10-20

narayanaqlik — Sat, 07 Dec 2019 08:18:14 GMT

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

Re: Which chart is suitable to present Distribution data across the scoring like 0-4,5-10,10-20

andoryuu — Sun, 08 Dec 2019 23:51:03 GMT

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.

topic Which chart is suitable to present Distribution data across the scoring like 0-4,5-10,10-20 in App Development

Which chart is suitable to present Distribution data across the scoring like 0-4,5-10,10-20

Re: Which chart is suitable to present Distribution data across the scoring like 0-4,5-10,10-20