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! Go to 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")
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")
You could also have a look at these types of a dimension:
https://docs.looker.com/reference/field-reference/dimension-type-reference#bin
https://docs.looker.com/reference/field-reference/dimension-type-reference#tier
Perhaps they could save you typing all that SQL
You could also have a look at these types of a dimension:
https://docs.looker.com/reference/field-reference/dimension-type-reference#bin
https://docs.looker.com/reference/field-reference/dimension-type-reference#tier
Perhaps they could save you typing all that SQL
Thank you for the helpful links. That worked for me!