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.4K Product Ideas
- 1.4K Ideas Exchange
- 1.4K Connect
- 1.1K Connectors
- 278 Workbench
- 4 Cloud Amplifier
- 4 Federated
- 2.7K Transform
- 89 SQL DataFlows
- 556 Datasets
- 2K Magic ETL
- 3.3K Visualize
- 2.3K Charting
- 569 Beast Mode
- 11 App Studio
- 27 Variables
- 579 Automate
- 141 Apps
- 414 APIs & Domo Developer
- 23 Workflows
- 1 DomoAI
- 28 Predict
- 12 Jupyter Workspaces
- 16 R & Python Tiles
- 351 Distribute
- 91 Domo Everywhere
- 258 Scheduled Reports
- 2 Software Integrations
- 92 Manage
- 89 Governance & Security
- 9 Product Release Questions
- Community Forums
- 42 Getting Started
- 28 Community Member Introductions
- 85 Community Announcements
- 4.8K Archive