4 Replies Latest reply: Nov 2, 2017 1:04 PM by Jordan Hertl

# Help with showing 'Percentage of numbers in a range'?

Hello all.

My chart is successfully showing the percentage of numbers above 4 like this...

Num(Count({<Score = {">=4"}>} Score) /Count(Score),'0%')

How would I go about altering this to show percentages in a range? For instance between 3.0 and 3.99?

Jordan

• ###### Re: Help with showing 'Percentage of numbers in a range'?

Num(Count({<Score = {">=4"}>} Score) /Count(Score),'0.0%')

Your expression would only show values which are greater or equal to 4.

If you want 3 as well then use

Num(Count({<Score = {">=3"}>} Score) /Count(Score),'0.0%')

or if you want all %'s

Num(Count({<Score = {">=0"}>} Score) /Count(Score),'0.0%')

• ###### Re: Help with showing 'Percentage of numbers in a range'?

Hi, thanks for the response.

Yes I know that the expression only shows value which are greater than or equal to 4.

I was wondering how I would write this expression to show a range of values. Specifically between 3.0 and 3.9.

• ###### Re: Help with showing 'Percentage of numbers in a range'?

Guess

Num(Count({<Score= {">=3<=3.9"}>} Score) /Count(Score),'0.0%')

• ###### Re: Help with showing 'Percentage of numbers in a range'?

That appears to have worked. Thanks for the help my friend.