Group and Count Results by Range?

Hi, I’ve got a results set that is a table calculated list of percentages. I’d like to group them by a range and display the count.

ie. 9%, 12%, 15%, 17%, 22%, 32%

Desired Results:

Range  Count
0-10%:    1
10-20%:  3
20-30%:  1
30-40%:  1
40-50%:  0

etc.

I’m very new to Looker and trying to do this from an Explore or SQL. Thank you!

 

Solved Solved
0 3 2,067
1 ACCEPTED SOLUTION

Solved this with a case(when) in a dimension and the count in a measure!

case(  
  when(${premium_change} <0, "<0%"),
  when(${premium_change} >=0 AND ${premium_change} <0.1,"0-10%"),
  when(${premium_change} >=0.1 AND ${premium_change} <0.2,"10-20%"),
  when(${premium_change} >=0.2 AND ${premium_change} <0.3,"20-30%"),
  when(${premium_change} >=0.3 AND ${premium_change} <0.4,"30-40%"),
  when(${premium_change} >=0.4 AND ${premium_change} <0.5,"40-50%"),
  when(${premium_change} >=0.5 AND ${premium_change} <0.6,"50-60%"),
  when(${premium_change} >=0.6 AND ${premium_change} <0.7,"60-70%"),
  when(${premium_change} >=0.7 AND ${premium_change} <0.8,"70-80%"),
  when(${premium_change} >=0.8 AND ${premium_change} <0.9,"80-90%"),
  when(${premium_change} >=0.9 AND ${premium_change} <1.0,"90-100%"),
  when(${premium_change} >=1.0,"100+%"),
  "Out of Range")
 

View solution in original post

3 REPLIES 3

Solved this with a case(when) in a dimension and the count in a measure!

case(  
  when(${premium_change} <0, "<0%"),
  when(${premium_change} >=0 AND ${premium_change} <0.1,"0-10%"),
  when(${premium_change} >=0.1 AND ${premium_change} <0.2,"10-20%"),
  when(${premium_change} >=0.2 AND ${premium_change} <0.3,"20-30%"),
  when(${premium_change} >=0.3 AND ${premium_change} <0.4,"30-40%"),
  when(${premium_change} >=0.4 AND ${premium_change} <0.5,"40-50%"),
  when(${premium_change} >=0.5 AND ${premium_change} <0.6,"50-60%"),
  when(${premium_change} >=0.6 AND ${premium_change} <0.7,"60-70%"),
  when(${premium_change} >=0.7 AND ${premium_change} <0.8,"70-80%"),
  when(${premium_change} >=0.8 AND ${premium_change} <0.9,"80-90%"),
  when(${premium_change} >=0.9 AND ${premium_change} <1.0,"90-100%"),
  when(${premium_change} >=1.0,"100+%"),
  "Out of Range")
 

Dawid
Participant V

Thank you for the helpful links. That worked for me! :thumbsup_tone4:

Top Labels in this Space
Top Solution Authors