Beast Mode Calculation Subtotal/Total

Hi There,

I have a beast mode calculating utilization and I want the calculation to occur in the subtotal and total as well however it is not doing that for HTML or Mega Table. It appears to be Summing or Counting.

Can someone please assist?


Please let me know how I can rectify this. Thanks!

Comments

  • GrantSmith
    GrantSmith Indiana πŸ”΄

    Hi @Shumilex

    You'll need to run your data through an ETL to calculate the totals for the dataset then append that row to your original dataset. You'd call the agent name "Grand Total". You can then add a beast mode to return 1 if it's not Grand Total and 2 if it is Grand Total and then sort by that then the agent name to make sure it's put at the bottom.

  • Shumilex
    Shumilex βšͺ️

    @GrantSmith this wouldn't fix the subtotal though? I've had other calculation that calculated using an HTML code. I'm just not sure why this isn't doing it.

  • GrantSmith
    GrantSmith Indiana πŸ”΄

    Subtotals would be the same issue where it's summing the values after the beast mode has done the calculations for the individual percentages. You'd need to calculate those subtotals in an ETL and stack them as well.