We have a daily metrics table (updated daily to Domo) which records revenue per product per date.
What we'd like to do is to calculate a rolling monthly average revenue per product as a beastmode, which is dynamic according to the date range selected by the end user in the card. This could then be grouped into custom tiers.
Tier examples for average monthly revenue could be as follows:
- Diamond = greater than $1M
- Platinum = $750k to $1M
- Gold = $500k to $750k
- Silver = $250k to $500k
- Bronze = lower than $250k
Is it possible to build such a beastmode for a dynamic average monthly revenue. And then further categorise in the tiers.
Our aim is to understand how products might move across tiers over time.
