Store values from daily average
Hi,
I need your help, my brain is frozen…;)
I am reporting on Support Cases in Salesforce.
Every day, I pull a report into Domo showing all cases per Case Record Type that are open that day.
E.g.
report pulled 6/9/23 says for CRT Support A 24 Open Cases and for CRT Support B 37
report pulled 6/8/2023 says CRT Support A 12 Open Cases and for CRT Support B 50
Is there anyway that I can store these values for each day in a separate file, which is then not overwritten, but each day the values are captured and added? Would using Variables do the trick?
Thanks for any ideas!!
Best Answer
-
Have you tried setting the update method on the connector dataset to be Append instead of Replace so it'll append each day's run to your dataset?
Alternatively if you're worried about duplicated records you could utilize a recursive dataflow (KB Article:
) to filter out duplicated records based on the logic you have.Variables wouldn't do it because they don't deal with storing data but rather how the data is interpreted.
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**0
Answers
-
Have you tried setting the update method on the connector dataset to be Append instead of Replace so it'll append each day's run to your dataset?
Alternatively if you're worried about duplicated records you could utilize a recursive dataflow (KB Article:
) to filter out duplicated records based on the logic you have.Variables wouldn't do it because they don't deal with storing data but rather how the data is interpreted.
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**0 -
Hi Grant!
I just stumbled accross this as well! That seems to be new….Looks like this is doing the trick. I set it now to update all 15 minutes and store it per minute…..
Thanks much again!
Caroline
1
Categories
- All Categories
- 1.8K Product Ideas
- 1.8K Ideas Exchange
- 1.6K Connect
- 1.2K Connectors
- 300 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 2.9K Transform
- 102 SQL DataFlows
- 626 Datasets
- 2.2K Magic ETL
- 3.9K Visualize
- 2.5K Charting
- 753 Beast Mode
- 61 App Studio
- 41 Variables
- 692 Automate
- 177 Apps
- 456 APIs & Domo Developer
- 49 Workflows
- 10 DomoAI
- 38 Predict
- 16 Jupyter Workspaces
- 22 R & Python Tiles
- 398 Distribute
- 115 Domo Everywhere
- 276 Scheduled Reports
- 7 Software Integrations
- 130 Manage
- 127 Governance & Security
- 8 Domo Community Gallery
- 38 Product Releases
- 11 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 110 Community Announcements
- 4.8K Archive