Beastmode to categorise product revenue by average monthly revenue

Options
jonathanlooker
jonathanlooker Member
in Charting

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.

Answers

  • MarkSnodgrass
    MarkSnodgrass Coach
    Options

    You are going to want to watch @jaeW_at_Onyx video on rolling averages https://www.youtube.com/watch?v=cnc6gMKZ9R8

    You will need to ask your CSM to enable Windows Functions in Beast Modes if it is not already enabled in order to what he explains. Your tiers would just be a case statement built on top of the rolling average beast mode.

    **Check out my Domo Tips & Tricks Videos

    **Make sure to <3 any users posts that helped you.
    **Please mark as accepted the ones who solved your issue.
  • jaeW_at_Onyx
    jaeW_at_Onyx Coach
    Options

    @Mark thanks for the shoutout; but also, you can't apply CASE statements AFTER aggregation. You'll have to use a Dataset View or ETL to pre-calculate avg monthly revenue, then use a CASE statement to assign tiers.

    https://youtu.be/Esnu1PSxRjM?t=621

    Jae Wilson
    Check out my 🎥 Domo Training YouTube Channel 👨‍💻

    **Say "Thanks" by clicking the ❤️ in the post that helped you.
    **Please mark the post that solves your problem by clicking on "Accept as Solution"

Categories