Help in Pivot

Hello, Requesting help on how to resolve this and appreciate your assistance.
My data in the table has Year, Quarter and all the measures. But user is requesting the report to be in the below format. Measures/Metrics on he left side while Timeframe on the top as columns. I am unable to do this in Pivot table view in the card.
The data source does not have the metrics in aggregate form. I was doing the calculations in the card. How do I do the aggregation and display the measures along with time frame in the below format.
Appreciate your help. I have done this in Tableau tool but I am confused on how to get this in Domo.
Best Answer
-
I've recorded this video walking through how to do this:
Let me know if you have any other questions!
If I solved your problem, please select "yes" above
1
Answers
-
I've recorded this video walking through how to do this:
Let me know if you have any other questions!
If I solved your problem, please select "yes" above
1 -
Woww!! That was quick.. Thanks so much for great tip and quick video!!
I was thinking that I will need to pivot the whole data set.. Glad that i asked this here.. Appreciate it very much!!
Thanks @ColemenWilson !!
0
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
- 655 Datasets
- 115 SQL DataFlows
- 2.2K Magic ETL
- 811 Beast Mode
- 3.3K Visualize
- 2.5K Charting
- 80 App Studio
- 45 Variables
- 771 Automate
- 190 Apps
- 481 APIs & Domo Developer
- 77 Workflows
- 23 Code Engine
- 36 AI and Machine Learning
- 19 AI Chat
- AI Playground
- AI Projects and Models
- 17 Jupyter Workspaces
- 410 Distribute
- 120 Domo Everywhere
- 280 Scheduled Reports
- 10 Software Integrations
- 142 Manage
- 138 Governance & Security
- 8 Domo Community Gallery
- 48 Product Releases
- 12 Domo University
- 5.4K Community Forums
- 41 Getting Started
- 31 Community Member Introductions
- 113 Community Announcements
- 4.8K Archive