How to Lock Down Month End Results
Hi All-
I'm looking for an easy way to lock down month end data/results. I have looked at both SQL and recursive ETL options. These are too complex for a novice user. My challenge is that a crystal report pulls month end data on 'loan status'. (We are trying to get away from these hard copy reports and use DOMO). When I pull a 'snapshot' of the database into a DOMO visual, let's say a week after month end, there are obviously changes to the dataset vs. month end. 'Loan status' has changed (i.e from approved to funded) and when I do a look back for month end, the DOMO output does not match the crystal report. What would be helpful is a flag or timestamp such that I can show what the output was at the last day of each month and archive it for future use.
Any 'simple' suggestions would be much appreciated. Thanks.
Trent
Comments
-
Is anyone able to help out with this request?
0 -
Hello Trent-T,
Thank you for posting your inquiry. The most simple solution would be to create a new dataset that runs once and pulls in your month-end data, but that may not be a viable solution if you have many reports and this may make it difficult to locate the right dataset when building a visualization due to the number of datasets that you would have as a result. The other option is more complicated. As you mentioned, you can accomplish your goal with a recursive dataflow, but this is a harder solution to implement. It sounds like you have considered these articles, but here are links if you wish to pursue that approach:
http://knowledge.domo.com?cid=recursiveetl
http://knowledge.domo.com?cid=recursivesql
If you have ideas of product features that you would like to see, please click on "Feedback" from the main navigation (grid icon) in your Domo account and provide an explanation of what you would like to see so our Product team can review the idea and consider it for future releases. Thank you!
Darius Rose
**Say “Thanks” by clicking the “heart” in the post that helped you.
**Please mark the post that solves your problem by clicking on "Accept as Solution"0 -
Thank you Darius for taking the time to respond. I will go down the recursive route and see if I can make it work. Cheers,
Trent
0 -
Thank you for getting back to me, Trent-T. If you run into trouble, please feel free to reach out to the Support team to get you back on track. Thank you for your time!
Darius Rose
**Say “Thanks” by clicking the “heart” in the post that helped you.
**Please mark the post that solves your problem by clicking on "Accept as Solution"0
Categories
- All Categories
- 1.7K Product Ideas
- 1.7K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 294 Workbench
- 6 Cloud Amplifier
- 8 Federated
- 2.8K Transform
- 97 SQL DataFlows
- 607 Datasets
- 2.1K Magic ETL
- 3.8K Visualize
- 2.4K Charting
- 707 Beast Mode
- 49 App Studio
- 39 Variables
- 667 Automate
- 170 Apps
- 446 APIs & Domo Developer
- 44 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