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
- 10.5K All Categories
- 7 Connect
- 917 Connectors
- 250 Workbench
- 464 Transform
- 1.7K Magic ETL
- 69 SQL DataFlows
- 477 Datasets
- 190 Visualize
- 252 Beast Mode
- 2.1K Charting
- 11 Variables
- 17 Automate
- 354 APIs & Domo Developer
- 89 Apps
- 3 Workflows
- 20 Predict
- 5 Jupyter Workspaces
- 15 R & Python Tiles
- 246 Distribute
- 62 Domo Everywhere
- 243 Scheduled Reports
- 21 Manage
- 42 Governance & Security
- 173 Product Ideas
- 1.2K Ideas Exchange
- 12 Community Forums
- 27 Getting Started
- 14 Community Member Introductions
- 55 Community News
- 4.5K Archive