How can I rotate row headers to column headers? I saw this at Domopalooza in March?
Comments
-
you will have to create a data flow (magic ETL) and use the uncollapse columns option.
Domo Arigato!
**Say 'Thanks' by clicking the thumbs up in the post that helped you.
**Please mark the post that solves your problem as 'Accepted Solution'0 -
Thank You, but I figured I would have to use both to do this; however, I was hoping for an example with steps, etc.
0 -
The help center has instructions how to use the option.
follow this link and scroll down to the bottom where it talks about the Uncollapse Columns option
https://knowledge.domo.com/Prepare/Magic_ETL_DataFlows/02Magic_ETL_DataFlows_Actions_Reference
Domo Arigato!
**Say 'Thanks' by clicking the thumbs up in the post that helped you.
**Please mark the post that solves your problem as 'Accepted Solution'0 -
I'm also having this requirement. I don't think the Uncollapse Columns helps me (went through the doc & test). So, here is what I want to achieve. Can you please help elaborate detailed steps?
Domo Arigato!
-- Hua
0 -
Hello Hua, if you still have a need for this please can you send me your source data from your screen shot? I can take a stab at this for you, I'm pretty comfortable with MagicETL.
Cheers, JJ.
0 -
-
-
Hello Hua, what you're looking for is a Sumo card instead of a regular card.
Here's the result you're looking for :
When you click the add card button on a page, a grid of card options are shown. Choose 'Sumo' as shown here :
A Sumo card can show data as columns or as a crosstab. You need the crosstab view. Here is a screenshot for you of the card in creation mode :
When you select this option you actually get a much nicer tabular format too. I use Sumo cards for validating data too as they have some nice aggregate features.
Let us all know how you get on.
Cheers, JJ.
0 -
Thank you, @JJ.
I am aware of Sumo card type and do use it for some of my metrics. However the limitation of Sumo card not having drill-down capability is something I would like to workaround using normal table cards. When the rows are getting longer (too many column), I would like to be able to display the table with column as header. Another option, if Domo can implement, could be enable "panel freeze" like what Excel has, so viewers can still have the key columns locked while scrolling to further columns.
Thank you for your help!
0 -
@Hua,
Sounds like this may be a new idea for Domo, please feel free to post your suggestion in our Ideas Exchange so one of our product managers may review it for our road map.
Thanks!
0
Categories
- All Categories
- 1.7K Product Ideas
- 1.7K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 294 Workbench
- 6 Cloud Amplifier
- 8 Federated
- 2.8K Transform
- 97 SQL DataFlows
- 607 Datasets
- 2.1K Magic ETL
- 3.8K Visualize
- 2.4K Charting
- 707 Beast Mode
- 49 App Studio
- 39 Variables
- 667 Automate
- 170 Apps
- 446 APIs & Domo Developer
- 44 Workflows
- 7 DomoAI
- 33 Predict
- 13 Jupyter Workspaces
- 20 R & Python Tiles
- 391 Distribute
- 111 Domo Everywhere
- 274 Scheduled Reports
- 6 Software Integrations
- 115 Manage
- 112 Governance & Security
- Domo Community Gallery
- 31 Product Releases
- 9 Domo University
- 5.3K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 103 Community Announcements
- 4.8K Archive