pivot tile?
hi I am working in Magic ETL and am having a tough time knowing how to do what I am trying to do.
Below I have a dataset with 3 columns shown that I need.
What I need to be able to do is keep the msp last run date
on the left hand side but then pivot the `delinquent payment 2` into column names then show the loan count
So it would look something like this
I am using a pivot tile in magic etl and cannot configure it the correct way, any suggestions?
This set up does not work
If this helps, feel free to agree, accept or awesome it!
Best Answer
-
This should work:
That said, the format you have your data in already is ideal for most uses. You could also pivot it as is in a Pivot Table Card:
Please 💡/💖/👍/😊 this post if you read it and found it helpful.
Please accept the answer if it solved your problem.
1
Answers
-
This should work:
That said, the format you have your data in already is ideal for most uses. You could also pivot it as is in a Pivot Table Card:
Please 💡/💖/👍/😊 this post if you read it and found it helpful.
Please accept the answer if it solved your problem.
1 -
Thank you!
If this helps, feel free to agree, accept or awesome it!
0
Categories
- All Categories
- Product Ideas
- 2.1K Ideas Exchange
- Connect
- 1.3K Connectors
- 309 Workbench
- 7 Cloud Amplifier
- 10 Federated
- Transform
- 664 Datasets
- 119 SQL DataFlows
- 2.3K Magic ETL
- 823 Beast Mode
- Visualize
- 2.6K Charting
- 86 App Studio
- 46 Variables
- Automate
- 194 Apps
- 483 APIs & Domo Developer
- 89 Workflows
- 24 Code Engine
- AI and Machine Learning
- 23 AI Chat
- 4 AI Projects and Models
- 18 Jupyter Workspaces
- Distribute
- 119 Domo Everywhere
- 283 Scheduled Reports
- 11 Software Integrations
- Manage
- 143 Governance & Security
- 11 Domo Community Gallery
- 49 Product Releases
- 13 Domo University
- Community Forums
- 41 Getting Started
- 31 Community Member Introductions
- 116 Community Announcements
- 5K Archive