How to Create a Dynamic Pivot in Dataflow ?
I have a dataset that I would like to pivot on a certain column value, development month, that introuduces new unique values each time the data is refreshed.
The issue that I am having is that this field can change any time the dataset is updated. This is a rather large data set (2 million rows) and I'd like to avoid having to go in every month and figure out if there were new values added.
Also, the pivot columns should be a running total meaning that column 3 should be the sum of all values 1, 2, and 3. Column 6 should be the sum of all values from columns 1, 2, ,3 ,4 ,5 ,6. I would like this to be dynamic so that if I load the dataset today and there is new development month, say 84, then this is added as a column and the values from 1-84 summed as the value.
Any ideas how to do this in DOMO? I know how to do this is MSSQL but not in MySQL or Magic ETL.
- 10.7K All Categories
- 13 Getting Started in the Community
- 41 Beastmode & Analytics
- 2.1K Data Platform & Data Science
- 59 Domo Everywhere
- 2.7K Charting
- 2.5K Ideas Exchange
- 1.3K Connectors
- 362 Workbench
- 303 Use Cases & Best Practices
- 503 APIs
- 120 Apps
- 48 News
- 753 Onboarding
- 1.2K 日本支部
- Private Company Board