Beast Mode Calculation Subtotal/Total

Shumilex · 2021-09-01T16:27:36+00:00

There was an error rendering this rich post.

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!

Find more posts tagged with

Comments

GrantSmith

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

@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

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.