Creating a Pivot Table Card where the default view is COLLAPSED
Hi Everyone...
First post here. Just finished my professional cert level 1 to give you an idea of knowledge level.
I created a pivot table chart and by default I have a QTD date range broken out by weeks. My column hierarchy goes -> Week (based on our fiscal calendar) -> Campaigns -> dimensions/metrics.
We might be running 30-50 campaigns a week and as you can imagine the view is unwieldy when everything is expanded. I can't seem to find a way to enable the default view where everything is collapsed starting from the top (week). Is it even possible?
Comments
-
Hi @user32470
Have you tried utilizing a quick filter instead to view only the campaigns the user is interested? There isn't a default "collapsed" option (you could manually collapse all of them and then save the report but that'd be a weekly or daily process to keep updating the collapses)
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**0
Categories
- 7.7K All Categories
- Connect
- 917 Connectors
- 242 Workbench
- 474 Transform
- 1.8K Magic ETL
- 60 SQL DataFlows
- 446 Datasets
- 34 Visualize
- 198 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
- 23 Product Ideas
- 1.1K Ideas Exchange
- Community Forums
- 15 Getting Started
- 1 Community Member Introductions
- 49 Community News
- 18 Event Recordings
- 579 日本支部