Filter to Last 12 Months (dynamic)
I've got two data sets I am trying to combine in Magic ETL to calculate inventory turns. In the sales data I have 2 1/2 years of history that updates weekly. In the ETL in preparing the sales data I need to filter to just the last 12 months (from last date in the set). Since this last date updates each week I'd like to make this dynamic so each week when more data is availble this ETL moves forward so that the last 12 months (or 52 weeks) is represented in the data.
In the end my calculation is (Last 12 Months of Sales) / Current Inventory Value = Inventory Turns.
Any suggestions on how to take MAX Order Date - 12 Months?
Best Answer
-
I had a meeting yesterday with Ryan Moody and Zack Cameron from Domo and I took the opportunity to ask them for help. They gave me the solution!
In am posting this in case others have the same question.
Here is a short video I put together that provides the solution.
Please hit "LIKE" if you agree using videos like this is a good way to communicate.
7
Answers
-
I had a meeting yesterday with Ryan Moody and Zack Cameron from Domo and I took the opportunity to ask them for help. They gave me the solution!
In am posting this in case others have the same question.
Here is a short video I put together that provides the solution.
Please hit "LIKE" if you agree using videos like this is a good way to communicate.
7 -
Thank you! This is really cool and the video is very helpful
0 -
I absolutely hate videos as a way of communicating. Almost always, I could read an answer faster than I can watch it.
0
Categories
- All Categories
- 1.8K Product Ideas
- 1.8K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 300 Workbench
- 6 Cloud Amplifier
- 8 Federated
- 2.9K Transform
- 100 SQL DataFlows
- 616 Datasets
- 2.2K Magic ETL
- 3.9K Visualize
- 2.5K Charting
- 738 Beast Mode
- 56 App Studio
- 40 Variables
- 685 Automate
- 176 Apps
- 452 APIs & Domo Developer
- 47 Workflows
- 10 DomoAI
- 36 Predict
- 15 Jupyter Workspaces
- 21 R & Python Tiles
- 394 Distribute
- 113 Domo Everywhere
- 275 Scheduled Reports
- 6 Software Integrations
- 124 Manage
- 121 Governance & Security
- 8 Domo Community Gallery
- 38 Product Releases
- 10 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 108 Community Announcements
- 4.8K Archive