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
- 2K Product Ideas
- 2K Ideas Exchange
- 1.6K Connect
- 1.3K Connectors
- 310 Workbench
- 7 Cloud Amplifier
- 9 Federated
- 3K Transform
- 113 SQL DataFlows
- 653 Datasets
- 2.2K Magic ETL
- 4K Visualize
- 2.5K Charting
- 795 Beast Mode
- 78 App Studio
- 44 Variables
- 757 Automate
- 188 Apps
- 480 APIs & Domo Developer
- 72 Workflows
- 17 DomoAI
- 40 Predict
- 17 Jupyter Workspaces
- 23 R & Python Tiles
- 408 Distribute
- 119 Domo Everywhere
- 279 Scheduled Reports
- 10 Software Integrations
- 141 Manage
- 137 Governance & Security
- 8 Domo Community Gallery
- 47 Product Releases
- 12 Domo University
- 5.4K Community Forums
- 41 Getting Started
- 31 Community Member Introductions
- 114 Community Announcements
- 4.8K Archive