Increase number of dimensions allowed in the pivot table
Currently the pivot table chart only allows 10 dimensions on the top (rows fields). We need more than 10 dimensions often for data analysis.
Thanks!
Comments
-
Yes. DOMO needs to take this on priority as customers are using Excel sheet and they expect the as is in reporting tools.
1 -
@Domolola this limit has been increased recently so you should be able to add more than 10 dimensions as rows in your pivot table (assuming the number of columns is only 1. If you have a use case that requires a higher limit, I'd be interested to hear about it. Thanks!
We've updated the documentation in our knowledge base here:
Best Practices for Pivot Tables
To keep Pivot Tables organized and to avoid displaying unneeded data, the maximum number of queries that can be called is 36. To find this limit, use (NumberOfRowPills + 1) x (NumberOfColumnPills +1) <=36.
For example, a Pivot Table with 8-row pills and 1 column pill requires 18 queries to render:
8 rows x 1 column => (8+1) x (1+1) => 9 x 2 = 18 queries
Possible row and column combinations include:
1 x 17
2 x 11
3 x 8
4 x 6
5 x 5
6 x 4
8 x 3
11 x 2
17 x 1
When you drag a new value to a column or row, you must place the new value in one of the Drag Column Here boxes. Existing values are replaced when you drag over them.
The maximum number of columns allowed in a Values field is 50.
Matt Tannyhill
Domo – Product Manager
Data Analysis & Visualization
0
Categories
- All Categories
- 1.9K Product Ideas
- 1.9K Ideas Exchange
- 1.6K Connect
- 1.3K Connectors
- 302 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 2.9K Transform
- 104 SQL DataFlows
- 637 Datasets
- 2.2K Magic ETL
- 3.9K Visualize
- 2.5K Charting
- 762 Beast Mode
- 65 App Studio
- 42 Variables
- 704 Automate
- 182 Apps
- 458 APIs & Domo Developer
- 53 Workflows
- 11 DomoAI
- 39 Predict
- 16 Jupyter Workspaces
- 23 R & Python Tiles
- 401 Distribute
- 116 Domo Everywhere
- 277 Scheduled Reports
- 8 Software Integrations
- 133 Manage
- 130 Governance & Security
- 8 Domo Community Gallery
- 38 Product Releases
- 12 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 111 Community Announcements
- 4.8K Archive