How can i achieve the below grouped calculation in a beast mode?

MayaU_01
MayaU_01 Member
in Beast Mode

Hello Team,

How can i achieve the below calculation in a beast mode.

sum(MAX(SUM(`metric1`) 
OVER (PARTITION BY `Metric2`, `metric3')) 
OVER (PARTITION BY `Metric2`, `metric3`))

If its not possible in domo beast mode then can you please suggest a way to achieve it in any other feature?

Tagged:

Answers

  • ArborRose
    ArborRose Coach

    I think because of the nesting, you will need to look at a Magic ETL.

    Group by Metric1, Group by Metric2, Group by Metric3. Then use Rank and Window to find MAX(SUM(Metric1)) for each partition. And another Group By to sum the max values.

    SQL performance in Domo is horrendous. I am definitely not pointing you to that.

    ** Was this post helpful? Click Agree or Like below. **
    ** Did this solve your problem? Accept it as a solution! **

  • MarkSnodgrass
    MarkSnodgrass Coach

    Can you provide some sample data of what you have and what you want the end result to look like? It is a bit unclear what you are trying to do when you have 3 aggregators.

    **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.
  • MayaU_01
    MayaU_01 Member
    Sample book.xlsx

    I have tried to replicate the sample here calculation here.

    Here is the sample @MarkSnodgrass

Categories