Forum Discussion

rvickersevotix's avatar
rvickersevotix
Cloud Apps
08-16-2022
Solved

Grouping Data Into Ranges - Front End

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 c...
  • harikm007's avatar
    harikm007
    08-16-2022

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

    Formula would be:

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

    -Hari