cancel
Showing results for 
Search instead for 
Did you mean: 

Grouping Data Into Ranges - Front End

rvickersevotix
7 - Data Storage
7 - Data Storage

I have a set of data that gives out a Numerical Number for MAX(Score).

I want to count the number of each record that falls into a set of ranges.

100-96, 95-90, 89-85, 84-80, 79-75 and <75

My case statement is starting like this:

Case
When (max([Score]) > 96) then '100%-96%'
when (max([Score]) < 96) and (max([Score]) > 90) then '95%-90%'
when (max([Score]) < 90) and (max([Score]) > 85) then '89%-85%'
when (max([Score]) < 85) and (max([Score]) > 79) then '84%-80%'
when (max([Score]) < 79) and (max([Score]) > 74) then '79%-75%'
when (max([Score]) < 74) then 'below 75%'
end

Now I know that this doesnt work, because I need to be specific to Numbers I think, but I'm hoping someone can guide me in the right direction.

I am a complete noob when it comes to this.

1 ACCEPTED SOLUTION

Are you using Column/Bar/Line chart? If yes,  another option is to create separate value panels for each category.

harikm007_0-1660650797843.png

Formula would be:

sum([Item ID], case when max([Value]) >= 0 and max([Value]) < 25 then 1 else 0 end)

-Hari

 

View solution in original post

4 REPLIES 4

harikm007
13 - Data Warehouse
13 - Data Warehouse

Hi @rvickersevotix ,

You will be able to group records using Dynamic Bucket plugin

-Hari

rvickersevotix
7 - Data Storage
7 - Data Storage

Firstly, thank you, I will suggest that to my product team.

Lets say I dont have access to make changes like that and I'm limited to front end case statements, If statements and script changes only?

Are you using Column/Bar/Line chart? If yes,  another option is to create separate value panels for each category.

harikm007_0-1660650797843.png

Formula would be:

sum([Item ID], case when max([Value]) >= 0 and max([Value]) < 25 then 1 else 0 end)

-Hari

 

Perfect, that will do nicely!