Beast Mode Calculation Subtotal/Total

Shumilex
Shumilex Member
in Charting

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?


image.png
image.png

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

Comments

  • GrantSmith
    GrantSmith Coach

    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.

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

    @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 Coach

    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.

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

Categories