Hey guys,
I have a dataset that appends each day to include the daily downloads, and resets the calculation on the 1st of every month.
This issue is, it's cumulative totals, so if yesterday we had 40 downloads and the following day we had 15 downloads, the total for the following day would come in as 55 total downloads.
What I want to do is capture the difference so I could get daily downloads.
I was using the Date Format widget in Magic ETL, but realized that it's not as simple because if the data resets each month, the last day of the month is a final cumulative sum of all downloads. So If the 31st had 24567 downloads and the 1st says 12, 24567-12 is not accurate.
I've included some sample data so you can see what I mean. I may be overthinking this.