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! **

Categories