Magic ETL

Magic ETL

Using Total as figure in Beast calc

This might be obvious, but I couldn't find how to do this. Is it possible to use the total figure (row total) as an individual figure in beast mode calcs? I have tried to do the following calc:

 

Amount/SUM(Amount)

 

The above calc is only doing the calculation on a row by row basis and is not using the sum figure/total figure.

Best Answer

  • Domo Employee
    Answer ✓

    You're not able to do this at the card level and would need to calculate this at within your ETL/Data Transform process. 

     

    Calculations at the card level are viewed "row-by-row" so if your calculation is comparing Amount in Row 1, a SUM(Amount) would only return the amount of Row 1 at Row 1 since it's not grouped and still broken out by each row. 

     

    An alternative would be to calculate the SUM(Amount) ahead of time and add it as a constant value column to your dataset. This would let you do Amount / (Precalculated SUM(Amount)) for each row.

     

    Let me know if you have any other questions,

    Valiant_Ronin

     

    **Please mark "Accept as Solution" if this post solves your problem
    **Say "Thanks" by clicking the "heart" in the post that helped you.

Answers

  • Domo Employee
    Answer ✓

    You're not able to do this at the card level and would need to calculate this at within your ETL/Data Transform process. 

     

    Calculations at the card level are viewed "row-by-row" so if your calculation is comparing Amount in Row 1, a SUM(Amount) would only return the amount of Row 1 at Row 1 since it's not grouped and still broken out by each row. 

     

    An alternative would be to calculate the SUM(Amount) ahead of time and add it as a constant value column to your dataset. This would let you do Amount / (Precalculated SUM(Amount)) for each row.

     

    Let me know if you have any other questions,

    Valiant_Ronin

     

    **Please mark "Accept as Solution" if this post solves your problem
    **Say "Thanks" by clicking the "heart" in the post that helped you.

Welcome!

It looks like you're new here. Members get access to exclusive content, events, rewards, and more. Sign in or register to get started.
Sign In