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!
Yes. DOMO needs to take this on priority as customers are using Excel sheet and they expect the as is in reporting tools.
@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:
https://domo-support.domo.com/s/article/360043429473?language=en_US#best_practices
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.
Alerts Product Enhancement Ideas
Analyzer Product Enhancement Ideas
API Product Enhancement Ideas
Apps Product Enhancement Ideas
Appstore product enhancement ideas
App Studio Product Enhancement Ideas
Beast Mode Product Enhancement Ideas
Buzz & Navigation Ideas
Charting product enhancement requests
Cloud Amplifier Product Enhancement Ideas
Code Engine Product Enhancement Ideas
Ideas or feedback for the Domo Community or the Community Forums.
Connectors Product Enhancement Ideas
Dashboard Product Enhancement Ideas
Datasets Produce Enhancement Ideas
Domo AI Product Enhancement Ideas
Domo Bricks Product Enhancement Ideas
Domo Developer Product Enhancement Ideas
Domo Everywhere Product Enhancement Ideas
Federated Product Enhancement Ideas
Product enhancement ideas for Domo as a whole
Governance & Security Product Enhancement Ideas
Jupyter Workspaces Product Enhancement Ideas
Localization product enhancement ideas
Magic ETL Product Enhancement Ideas
Mobile Product Enhancement Ideas
Reporting Product Enhancement Ideas
Product enhancement ideas for Sandbox
Software integrations product enhancement ideas
SQL Dataflows Product Enhancement Ideas
Variables Product Enhancement Ideas
Workbench Product Enhancement Ideas
Workflows Product Enhancement Ideas
Other Product Enhancement Ideas