Solved: Creating Custom Categories for Income Groups and T... - Page 2

tanvir2601 · 05-13-2024 02:03 PM

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?

salehaxsid

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.

View solution in original post

Creating Custom Categories for Income Groups and Tracking Yearly Counts