I have a dimension holding Customers and a measure which calculates total order_amount
I have ranked the customers based on the order_amount using a measure since Looker won't allow me to create a dimension using a measure (I use the sql: property to calculate the rank).
Now, I want to create buckets of 0-100 rank customers , 100-200 rank customers and so on but again I get the error that I can't use a measure in dimension. I can't create this buckets as measure since then I am not able to properly use it in the visualisation
How can I achieve this?