Comparing values based on their update in google sheets
I am stuck with a very simple yet hard to design dataflow in domo. So just to elaborate my problem, I have a some google sheets where data gets updated once or twice in a month by our different sales team members. Now they have asked me to build a dashboard where I could show them difference between the values or figures from the latest vs last update in the spreadsheet.
The problem is that there is no date column for reference. I just want to automate the process so that whenever they update the numbers in the google sheet, the dashboard table should update automatically and shows the difference or delta value form the previous update. I do not want to do any manual update in the process. Does anybody has some suggestion for me on how to do this in domo?
I can use google sheets connector to get the latest values in domo. But I have to store the values from last update date as well in some dataset. I am not able to figure out how to do that in a automated way.