Trimming Pivot Table to Only Display Items with Top Totals
Best Answers
-
@afieweger have you tried adding a card filter with an aggregation?
0 -
Filtering pivot tables is often tricky, specially if you're expecting the data displayed to be responsive to filters on the page or dashboard level, and even more if you want to limit to a specific top "X". If a less restrictive approach is acceptable, you can build a BeastMode that tells you the actual total for each row at the level you want, and filter the table to only include those that are above a certain threshold, something like:
SUM(SUM(`Views`) FIXED(BY `Page title`))
Then you can use this as the Sorting and Filter of the Pivot Table:
While it won't limit it to the top X, you can rule out anything that you'd consider to be noise by setting up a threshold after which you do want to show things. In this case I did
TotalViews >= 2000
as my filter.The reason you need a BeastMode with the fixed function is that otherwise the filter will apply to the level of the SUM of the fields, so in my case that the Quarterly views on each quarter, so it all depends on what you need.
1
Answers
-
@afieweger have you tried adding a card filter with an aggregation?
0 -
Filtering pivot tables is often tricky, specially if you're expecting the data displayed to be responsive to filters on the page or dashboard level, and even more if you want to limit to a specific top "X". If a less restrictive approach is acceptable, you can build a BeastMode that tells you the actual total for each row at the level you want, and filter the table to only include those that are above a certain threshold, something like:
SUM(SUM(`Views`) FIXED(BY `Page title`))
Then you can use this as the Sorting and Filter of the Pivot Table:
While it won't limit it to the top X, you can rule out anything that you'd consider to be noise by setting up a threshold after which you do want to show things. In this case I did
TotalViews >= 2000
as my filter.The reason you need a BeastMode with the fixed function is that otherwise the filter will apply to the level of the SUM of the fields, so in my case that the Quarterly views on each quarter, so it all depends on what you need.
1
Categories
- All Categories
- 1.8K Product Ideas
- 1.8K Ideas Exchange
- 1.6K Connect
- 1.2K Connectors
- 300 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 2.9K Transform
- 101 SQL DataFlows
- 622 Datasets
- 2.2K Magic ETL
- 3.9K Visualize
- 2.5K Charting
- 748 Beast Mode
- 59 App Studio
- 41 Variables
- 686 Automate
- 176 Apps
- 453 APIs & Domo Developer
- 47 Workflows
- 10 DomoAI
- 36 Predict
- 15 Jupyter Workspaces
- 21 R & Python Tiles
- 396 Distribute
- 113 Domo Everywhere
- 276 Scheduled Reports
- 7 Software Integrations
- 125 Manage
- 122 Governance & Security
- 8 Domo Community Gallery
- 38 Product Releases
- 10 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 109 Community Announcements
- 4.8K Archive