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

MayaU_01

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?

ArborRose

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.