I want to make a custom category to group people based on how much they've earned, like those who earned over $100K or $1M. Then, I want to count how many people fall into these categories each year, like in 2021, 150 people earned over $100K and 25 earned over $1M. Can I do this using custom dimensions and measures?
Solved! Go to Solution.
You can use dimension with type tier to bucket data according to tier [ >1000, >10000] etc.
and create a measure to count tier you will have the result.
For reference you can check:
Dimension, filter, and parameter types | Looker | Google Cloud
Hope this solves the issue, you can mark it as solution.
You can use dimension with type tier to bucket data according to tier [ >1000, >10000] etc.
and create a measure to count tier you will have the result.
For reference you can check:
Dimension, filter, and parameter types | Looker | Google Cloud
Hope this solves the issue, you can mark it as solution.
Excellent! It was a great help.
LinkedIn
Twitter
