Pivot Table Average Summaries instead of Totals
Hi all,
With the new pivot table card designs we can add Totals and Sub Totals which is great and sums values into collapsable groups. I can't seem to see a way to set a similar summary using a different aggregation like average, count, min and max.
For example, I have data showing a number of staff working hours which are then grouped by managers. The current Total options can show there working hours summed but I require to show those as an average instead. Would anyone know of a way to do this in pivot table cards?
Many thanks in advance,
Adam.
Comments
-
The total and subtotal assume the aggregation fuction you use on your variable. If you use SUM on variable hours, total and subtotal will use SUM too. Maybe try to add the same column and use average?
1 -
Make sure you know which Average you want when you use the subtotals.
See my screenshot.
with AVG() aggregation , you'll get the 'row average'. In my example SUM() / COUNT() = 1.7k on the subtotal. this is 'normal average' or rin my case 'the average transaction amount'
But if in your subtotal you're looking for the aggregated average, in my case 111,000 / 2 (different GL codes) = 55k, then you need a different beast mode.
sum(sum(amount)) over (partition by `Global Dimension 1 Code`) /
sum(count(distinct AccountNo)) over (partition by `Global Dimension 1 Code`)
Jae Wilson
Check out my 🎥 Domo Training YouTube Channel 👨💻
**Say "Thanks" by clicking the ❤️ in the post that helped you.
**Please mark the post that solves your problem by clicking on "Accept as Solution"1
Categories
- All Categories
- 1.8K Product Ideas
- 1.8K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 300 Workbench
- 6 Cloud Amplifier
- 8 Federated
- 2.9K Transform
- 100 SQL DataFlows
- 616 Datasets
- 2.2K Magic ETL
- 3.8K Visualize
- 2.5K Charting
- 738 Beast Mode
- 56 App Studio
- 40 Variables
- 684 Automate
- 176 Apps
- 452 APIs & Domo Developer
- 46 Workflows
- 10 DomoAI
- 35 Predict
- 14 Jupyter Workspaces
- 21 R & Python Tiles
- 394 Distribute
- 113 Domo Everywhere
- 275 Scheduled Reports
- 6 Software Integrations
- 123 Manage
- 120 Governance & Security
- 8 Domo Community Gallery
- 38 Product Releases
- 10 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 108 Community Announcements
- 4.8K Archive