What would be the downside of using Appended Data to capture M/M snapshots?
What would be the downside of using Appended Data to capture M/M snapshots?
Let me explain. My EVP of Services wants to see Month over Month or Quarter over Quarter closure rates for client projects. My thought was to pull the project data from SFDC and simply COUNT projects in status 'Closed', and then the Appended data the for the new month will give me a new count of Projects closed during that month. We are not talking thousands of records, so it wont bloat the DB, but I'm looking for a good way to do this, not just simple.
Thoughts?
Best Answer
-
I'm a big fan of if it works and gets results fast without being a huge resource sink then don't over think it.
When it comes to comparing periods in my shop I like the ability to use any chart I want rather than being restricted to period over period charts. So what I tend to do is append one dataset to itself, increment the dates by one year (or whatever you need to do to properly compare dates), then rename the appended value columns 'LY <<Column Name>>'.
Here's a simple example
Doing it this way allows you to create charts like this that can compare periods, quarters, years, days... can even be forward looking.
If you want to make sure it's apples to apples and not forward looking, (in this case, Jan, Feb, March of 2022 vs the prior year and nothing else), simply create a column or a beastmode that says if the LY Sales date is more than the max of the original tbl date, exclude it.
Hope this helps.
1
Answers
-
I'm a big fan of if it works and gets results fast without being a huge resource sink then don't over think it.
When it comes to comparing periods in my shop I like the ability to use any chart I want rather than being restricted to period over period charts. So what I tend to do is append one dataset to itself, increment the dates by one year (or whatever you need to do to properly compare dates), then rename the appended value columns 'LY <<Column Name>>'.
Here's a simple example
Doing it this way allows you to create charts like this that can compare periods, quarters, years, days... can even be forward looking.
If you want to make sure it's apples to apples and not forward looking, (in this case, Jan, Feb, March of 2022 vs the prior year and nothing else), simply create a column or a beastmode that says if the LY Sales date is more than the max of the original tbl date, exclude it.
Hope this helps.
1
Categories
- All Categories
- 1.8K Product Ideas
- 1.8K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 297 Workbench
- 6 Cloud Amplifier
- 8 Federated
- 2.9K Transform
- 100 SQL DataFlows
- 616 Datasets
- 2.2K Magic ETL
- 3.8K Visualize
- 2.5K Charting
- 729 Beast Mode
- 54 App Studio
- 40 Variables
- 678 Automate
- 173 Apps
- 451 APIs & Domo Developer
- 46 Workflows
- 8 DomoAI
- 34 Predict
- 14 Jupyter Workspaces
- 20 R & Python Tiles
- 394 Distribute
- 113 Domo Everywhere
- 275 Scheduled Reports
- 6 Software Integrations
- 121 Manage
- 118 Governance & Security
- Domo Community Gallery
- 32 Product Releases
- 10 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 108 Community Announcements
- 4.8K Archive