Period over period on one row
For this particular use case I have data like below
Date | Value
I need to transform this to
Date | Value | Date LY | Value LY
I could join the source data up like this to itself when pulling the data into domo via SQL but would rather do this in domo.
I attempted to use the period over period dimension stuff made by @GrantSmith (which is great and we are using) but the beastmodes look at 1 row at a time and for this particular use case a calculated value I am making needs access to this year data so needs to be on the same row.
I have looked at a MySQL dataflow but you can't join a dataset to itself and the same with the Views.
Would I have to copy the dataset multiple times?
- 7.3K All Categories
- 13 Getting Started in the Community
- 141 Beastmode & Analytics
- 1.8K Data Platform & Data Science
- 54 Domo Everywhere
- 2K Charting
- 1K Ideas Exchange
- 903 Connectors
- 236 Workbench
- 342 APIs
- 77 Apps
- 19 Governance & Productivity
- 235 Use Cases & Best Practices
- 50 News
- 473 Onboarding
- 573 日本支部