Trailing Totals Deep Dive
Yesterdays Community Meeting was awesome with lots of valuable insights, but was wondering if someone could elaborate a bit more on how the trend SQL works, I know we saw 2 of the transforms but I'm having a hard time figuring out the rest, like how is information being filled so that the rows 91-1 represent consecutive days.
Best Answer
-
@marcel_luthi they key to consecutive days is to add the Domo Dimension Calendar which has a row for every day. Joining your data to that will ensure consecutive days.
**Check out my Domo Tips & Tricks Videos
**Make sure to any users posts that helped you.
**Please mark as accepted the ones who solved your issue.1
Answers
-
@marcel_luthi they key to consecutive days is to add the Domo Dimension Calendar which has a row for every day. Joining your data to that will ensure consecutive days.
**Check out my Domo Tips & Tricks Videos
**Make sure to any users posts that helped you.
**Please mark as accepted the ones who solved your issue.1 -
I get that we join the calendar one with each possible granularity we want to be able to break things to, which would be the base table to which we'll then left join all the trailing calculations we've performed in the other transforms (or at least I think that is why there are so many there), but I'm guessing we're also filling blanks for each granularity for those somehow so that there will no missing entries when we try to roll things up, but now that I write it down I guess I'm starting to get it, we'll do an append of this one to the raw data one, to ensure we have at least one entry per combination per day, and once we roll up since the other fields will be null these won't affect the calculation but ensure we're actually rolling up the last N calendar days and not the last N days with entries. (Sorry this might sound confusing)
0
Categories
- All Categories
- 1.7K Product Ideas
- 1.7K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 295 Workbench
- 6 Cloud Amplifier
- 8 Federated
- 2.8K Transform
- 97 SQL DataFlows
- 608 Datasets
- 2.1K Magic ETL
- 3.8K Visualize
- 2.4K Charting
- 710 Beast Mode
- 49 App Studio
- 39 Variables
- 668 Automate
- 170 Apps
- 446 APIs & Domo Developer
- 45 Workflows
- 7 DomoAI
- 33 Predict
- 13 Jupyter Workspaces
- 20 R & Python Tiles
- 391 Distribute
- 111 Domo Everywhere
- 274 Scheduled Reports
- 6 Software Integrations
- 115 Manage
- 112 Governance & Security
- Domo Community Gallery
- 31 Product Releases
- 9 Domo University
- 5.3K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 103 Community Announcements
- 4.8K Archive