Is there a way to have pivot tables collapsed by default?

How do I set up a pivot table, so by default the rows are collapsed?
Best Answer
-
You have to manually collapse them while you are in Analyzer. Once you save it in Analyzer with them collapsed, they will be collapsed for the card viewer.
**Check out my Domo Tips & Tricks Videos
**Make sure toany users posts that helped you.
**Please mark as accepted the ones who solved your issue.0
Answers
-
You have to manually collapse them while you are in Analyzer. Once you save it in Analyzer with them collapsed, they will be collapsed for the card viewer.
**Check out my Domo Tips & Tricks Videos
**Make sure toany users posts that helped you.
**Please mark as accepted the ones who solved your issue.0 -
thanks @MarkSnodgrass what happens when new rows (values) are pulled in. Do I have to go back in and manually collapse them as well?
0 -
I only have a couple cards where I have this set up, so I can't say with 100% certainty, but I think you will have to go in and collapse those. Would definitely be something to monitor after you initially roll it out.
As an alternative, you can have your main card be the summary totals, and then make a drill path on the main card to show the details. Then, you wouldn't have to worry about the expand/collapse functionality.
**Check out my Domo Tips & Tricks Videos
**Make sure toany users posts that helped you.
**Please mark as accepted the ones who solved your issue.0 -
New values would need to be manually collapsed. I'd recommend adding an idea to the idea exchange to allow a setting so that all groups start collapsed as doing this manually for many different rows can be tedious.
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**1
Categories
- All Categories
- 2K Product Ideas
- 2K Ideas Exchange
- 1.6K Connect
- 1.3K Connectors
- 311 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 3.8K Transform
- 659 Datasets
- 116 SQL DataFlows
- 2.2K Magic ETL
- 815 Beast Mode
- 3.3K Visualize
- 2.5K Charting
- 82 App Studio
- 45 Variables
- 775 Automate
- 190 Apps
- 481 APIs & Domo Developer
- 81 Workflows
- 23 Code Engine
- 40 AI and Machine Learning
- 20 AI Chat
- 1 AI Playground
- 1 AI Projects and Models
- 18 Jupyter Workspaces
- 410 Distribute
- 120 Domo Everywhere
- 280 Scheduled Reports
- 10 Software Integrations
- 144 Manage
- 140 Governance & Security
- 8 Domo Community Gallery
- 48 Product Releases
- 12 Domo University
- 5.4K Community Forums
- 41 Getting Started
- 31 Community Member Introductions
- 114 Community Announcements
- 4.8K Archive