How do I get my subtotal and total rows in Table card to show the avg of % rather than the sum of %?
For the column of my table that's using percentages, I'm getting these percentages through a beast mode:
count(`Opportunity.CreatedDate`) /
(case when `Team Months Active` <= 1 then 40
when `Team Months Active` = 2 then 80
when `Team Months Active` = 3 then 120
else 160
end)
For some reason, the Total and Subtotal rows of my table are summing up these averages instead of giving me the average of the total averages. I've tried using Table and Pivot Table cards and it's doing it on both. How do I get the total to reflect the average?
Answers

@RobSomers this didn't work.
0 
@MichelleH this calculation is to calculate the team's current percentage of their monthly goal. The team monthly goals are ramped up each month from their first month as a team to their 4th month. So, those teams active 1 month or less will have a goal of 40, those with 2 months or less will have a goal of 80 etc.
0 
@lb1234 In that case, I recommend using an ETL to aggregate the data by team first so that you have a columns in your dataset for team, count of create date (numerator), and team goal (denominator). Then you can set up a beast mode in your card to calculate the percent of goal, like below:
sum(`Count of Create Date`) / sum(`Team Goal`)
1
Categories
 10.6K All Categories
 13 Getting Started in the Community
 29 Beastmode & Analytics
 2.1K Data Platform & Data Science
 59 Domo Everywhere
 2.7K Charting
 2.4K Ideas Exchange
 1.3K Connectors
 362 Workbench
 300 Use Cases & Best Practices
 499 APIs
 118 Apps
 48 News
 753 Onboarding
 1.1K 日本支部
 4 Private Company Board