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
 7.7K All Categories
 5 Connect
 921 Connectors
 244 Workbench
 477 Transform
 1.8K Magic ETL
 60 SQL DataFlows
 446 Datasets
 40 Visualize
 199 Beast Mode
 2K Charting
 8 Variables
 1 Automate
 348 APIs & Domo Developer
 82 Apps
 Workflows
 14 Predict
 3 Jupyter Workspaces
 11 R & Python Tiles
 241 Distribute
 59 Domo Everywhere
 241 Scheduled Reports
 15 Manage
 36 Governance & Security
 28 Product Ideas
 1.1K Ideas Exchange
 Community Forums
 14 Getting Started
 1 Community Member Introductions
 49 Community News
 18 Event Recordings
 579 日本支部