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
-
Yes with a connector, this sounds like exactly what I needed. Thank you very much!
0
Categories
- 10.8K All Categories
- 3 Private Company Board
- 1 APAC User Group
- 12 Welcome
- 38 Domo News
- 9.7K Using Domo
- 1.9K Dataflows
- 2.5K Card Building
- 2.2K Ideas Exchange
- 1.2K Connectors
- 343 Workbench
- 259 Domo Best Practices
- 11 Domo Certification
- 464 Domo Developer
- 50 Domo Everywhere
- 105 Apps
- 714 New to Domo
- 85 Dojo
- Domopalooza
- 1.1K 日本支部
- 4 道場-日本支部へようこそ
- 26 お知らせ
- 64 Kowaza
- 299 仲間に相談
- 653 ひらめき共有