Capture Card Summary data on a schedule
Hello. I have a card that is continually counting how many "wigets" meet a certain criteria. The number changes hourly.
I'd like to capture that card's Summary number at various intervals (maybe hourly) during the day so I can report on trends. Any easy way to do this?
Unfortunately the source data changes when it updates so the summary info is not stored for historic viewing at a later date.
Comments
-
Hi @colinr
You'd likely want to configure a recursive dataflow with some additional steps to summarize your data before storing it. There's a good writeup in the knowledge base on how to do this.
MySQL ETL Version: https://knowledge.domo.com/Prepare/DataFlow_Tips_and_Tricks/Creating_a_Recursive%2F%2FSnapshot_SQL_DataFlow
Magic ETL Version: https://knowledge.domo.com/Prepare/DataFlow_Tips_and_Tricks/Creating_a_Recursive%2F%2FSnapshot_ETL_DataFlow
If you just want the raw data itself you might want to look into the DataSet Copy connector pull your dataset and set it to append mode (this wouldn't allow you to get the summary number, just the raw data which you could then summarize later - give you more flexibility but takes up more rows)
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**1
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
- 57 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