I know looker has a Dimension type of tier but can I create a tier for a measure.
Use Case: I need to count the transactions for a buyer and determine which tier that buyer is in.
Name | Trucks Purchased
Company1 | 30-40
Company2 | 20-30
Or create a histogram of the numbe of companies in each range (‘Trucks Purchased’)
[Analytic Block] User Loyalty and Other User Attributes
@lloydtabb - Are you basically saying that he will need to create a derived table first to aggregate each company’s “Trucks Purchased”, then bring them in as dimensions so that he can tier them?
If that’s the case, how would you be able to make this dynamic? e.g. Be able to view the # of Trucks Purchased at varying timeframes.
Assuming the derived table from this model on learn.looker.com
We can use the lifetime number of orders tier, and count the number of users in each tier.
Suppose we want a 30 day count (the number of orders in the last 30 days)? We would add another computed value in the derived table query.
then the dimensions
You could also do this dynamically using parameters, but it makes for a confusing enduser experience. Adding an attribute on user, number of 30 day orders, its probably the best bet.