Pivot table type view
Is there a way to have a pivot table-like view in Domo (that sums up columns and rows)? Our users predominantly use iPads and my understanding is that sumo cards don't work on the iOS app. We currently use heat maps to get our variances, but one drawback is that there is no total by category. Is there any other card type that can replicate this functionality?
Comments
-
Sumo cards are the primary method for replicating pivot like views, but you are correct they aren't supported currently on iOS app.
One solution to consider would be creating a Magic ETL job using the Uncollapse Columns component which will group rows into columns...so essentially you could munge the data into columnar summaries and then use a standard table card with the Total/Subtotal feature to be summaries by column (https://knowledge.domo.com?cid=etlactionseditcolumns)
Does this help?
Jacob Folsom
**Say “Thanks” by clicking the “heart” in the post that helped you.
**Please mark the post that solves your problem by clicking on "Accept as Solution"2 -
Is there a way to get this type of functionality in a heat map? Currently, we use the heat map so we can drill into more detail. If we followed your suggestion, would we still be able to drill-through on a table's row/column intersection?
1 -
The biggest difference when drilling into a table versus a heat map is that drilling into a table will only apply one filter. Drilling into a heat map typically applies two filters.
“There is a superhero in all of us, we just need the courage to put on the cape.” -Superman1 -
We definitely want two filters. Is it possible to get totals on a heat map?
1 -
Currently, Sumo table is the best option for replicating Pivot table functionality.
Yes, you cannot see Sumo table on iOS.
Please submit an enhancement request via Feedback.
Thank you,
0 -
Please click on "Accept as Solution" on any reply that may have solved your problem.
Thanks!
0 -
We were running into a similar problem over and over, so we decided to publish our fix as an app in the app store. If you search RXA in the app store it will pop up.
A few more details here:
https://dojo.domo.com/t5/Appstore/Pivot-Table-App-In-the-App-Store/m-p/30764
--J
0
Categories
- All Categories
- 1.8K Product Ideas
- 1.8K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 297 Workbench
- 6 Cloud Amplifier
- 8 Federated
- 2.9K Transform
- 100 SQL DataFlows
- 614 Datasets
- 2.2K Magic ETL
- 3.8K Visualize
- 2.5K Charting
- 729 Beast Mode
- 53 App Studio
- 40 Variables
- 677 Automate
- 173 Apps
- 451 APIs & Domo Developer
- 45 Workflows
- 8 DomoAI
- 34 Predict
- 14 Jupyter Workspaces
- 20 R & Python Tiles
- 394 Distribute
- 113 Domo Everywhere
- 275 Scheduled Reports
- 6 Software Integrations
- 121 Manage
- 118 Governance & Security
- Domo Community Gallery
- 32 Product Releases
- 10 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 108 Community Announcements
- 4.8K Archive