Keeping historical track of live data
Hello, I'm working with data from our CRM. To simplify things, let's say we only have one Pipeline, or sales vertical.
A very simplified version of what I'll have in my data set is two columns: Deal Title / Deal Value.
Deal A / $100
The data from our CRM is updated constantly and so the data points are always changing. That same deal in two weeks could be worth more:
Deal B / $250
The issue here is that there isn't a log kept of the deal values, so for example I can't say what the value of deals in our pipeline was last week compared to this week since the data is live and has already changed. The only way I see of doing this now is manually downloading the data the previous week and never updating it, then the following week downloading the data as a separate data set, making cards for each data set and then comparing the values. Is there a better way of doing this? Thank you in advance!
Best Answer
-
How are you loading the data into Domo ?
if using a connector, change the setting from Replace method to Append.
That will create an automated field that tags every row with the Batch Last Run Date which referes to the day your data is appended. That way you can look at what the data looked like in the past compared to the most recent update
Domo Arigato!
**Say 'Thanks' by clicking the thumbs up in the post that helped you.
**Please mark the post that solves your problem as 'Accepted Solution'1
Answers
-
How are you loading the data into Domo ?
if using a connector, change the setting from Replace method to Append.
That will create an automated field that tags every row with the Batch Last Run Date which referes to the day your data is appended. That way you can look at what the data looked like in the past compared to the most recent update
Domo Arigato!
**Say 'Thanks' by clicking the thumbs up in the post that helped you.
**Please mark the post that solves your problem as 'Accepted Solution'1 -
Yes with a connector, this sounds like exactly what I needed. Thank you very much!
0
Categories
- All Categories
- 1.8K Product Ideas
- 1.8K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 300 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 2.9K Transform
- 101 SQL DataFlows
- 622 Datasets
- 2.2K Magic ETL
- 3.9K Visualize
- 2.5K Charting
- 747 Beast Mode
- 59 App Studio
- 41 Variables
- 686 Automate
- 176 Apps
- 453 APIs & Domo Developer
- 47 Workflows
- 10 DomoAI
- 36 Predict
- 15 Jupyter Workspaces
- 21 R & Python Tiles
- 395 Distribute
- 113 Domo Everywhere
- 276 Scheduled Reports
- 6 Software Integrations
- 125 Manage
- 122 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