Quarterly Snapshots of Data
Hi gang!
A two part question where answers that a newbie like me can understand are very much appreciated please :)
- I need to build some cards consisting of quarterly snapshots of a dataset. The dates aren't fixed, and I would like to have control over when the snapshots are taken. What's the best way to go about this?
- In Excel, we have what is essentially our first two snapshots. Is it possible to get this into Domo to merge seamlessly with the snapshots from question #1?
Thanks!
Best Answer
-
The easiest way to do this is to set the update method of your data to "Append" instead of "Replace". This way, each time the data updates, it is added to the dataset as an append so you maintain a full history. You can set this to run on a schedule (quarterly) but can also manually update the data anytime you please.
For the excel data, you will need to take your dataset from above and append it in MagicETL with your excel data. There is a tile for this in MagicETL called "Append Rows"
If I solved your problem, please select "yes" above
0
Answers
-
The easiest way to do this is to set the update method of your data to "Append" instead of "Replace". This way, each time the data updates, it is added to the dataset as an append so you maintain a full history. You can set this to run on a schedule (quarterly) but can also manually update the data anytime you please.
For the excel data, you will need to take your dataset from above and append it in MagicETL with your excel data. There is a tile for this in MagicETL called "Append Rows"
If I solved your problem, please select "yes" above
0 -
Hi @ColemenWilson, thank you for the reply.
Should I be concerned about using Append because this is already by far our largest dataset, at 210,000 rows, 181 columns, and the data gets updated very frequently.
0 -
Yes, I would create a separate dataset that is for snapshotting purposes.
If I solved your problem, please select "yes" above
0
Categories
- All Categories
- 1.7K Product Ideas
- 1.7K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 292 Workbench
- 4 Cloud Amplifier
- 8 Federated
- 2.8K Transform
- 95 SQL DataFlows
- 603 Datasets
- 2.1K Magic ETL
- 3.7K Visualize
- 2.4K Charting
- 697 Beast Mode
- 43 App Studio
- 39 Variables
- 658 Automate
- 170 Apps
- 441 APIs & Domo Developer
- 42 Workflows
- 5 DomoAI
- 32 Predict
- 12 Jupyter Workspaces
- 20 R & Python Tiles
- 387 Distribute
- 111 Domo Everywhere
- 270 Scheduled Reports
- 6 Software Integrations
- 113 Manage
- 110 Governance & Security
- 9 Domo University
- 30 Product Releases
- Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 98 Community Announcements
- Domo Community Gallery
- 4.8K Archive