1 Reply Latest reply on Oct 30, 2013 3:05 PM by Tracy Rodgers

How do you detemine where individual scores fall within the 20%, 40%, 60%, 80% of 100% percentile of the lower and upper ranges of all the scores?

I am trying to use the product to help categorise risk assessments and rate the risk scores of those that fall with the 20/40/60/80/100 percentiles of the highest and lowest scores - e.g. if the risk scores were between -100 to 200 they could fall within the following brackets;

Insignificant rating - a score between -100 and -40,

Low rating - a score between -41 and 20

Medium rating - a score between 21 and 80

Significant rating - a score between 80 and 140

High rating - anything equal to or above a score of 141

When categoried I would use this information to colour the appropriate bar on the graph to one of five colors.

Can anyone provide an example of how this should work?

Many thanks

Dave

• 1. Re: How do you detemine where individual scores fall within the 20%, 40%, 60%, 80% of 100% percentile of the lower and upper ranges of all the scores?

Hi David,

Sorry for the delay in receiving a response. This can be done by creating a calculated field similar to the following:

if sum([Rating])<=-40 then "Insignificant"

elseif sum([Rating])<=20 then "Low"

elseif sum([Rating])<=80 then "Medium"

elseif sum([Rating])<=140 then "Significant"

else "High"

end

Then, place this on the color shelf of your bar chart.

Hope this helps!

-Tracy