I'm trying to compare the sum of costs in the last 7 days (including today) vs. 7 days prior to that. As an example, today is 10/30. I want to compare the sum of my Cost column from 10/23-10/30 vs. 10/15-10/22.
Whenever I choose to bin using weeks, it will show the data for the current week up until Saturday, Nov 2nd and compare that with the previous week. I've attached a screenshot of what that looks like.
How would I go about summing and comparing last 7 days to 7 days before that?
What are the last 2 rows of data you are fetching form the table? Cause the Trend will just pick those two rows and compare them so in your case you might need to group by week granulairty?
The data is currently being grouped by week - the problem is when the current day is, say Monday, it'll show me the numbers from the current week, and compare that with the full previous week.
For instance,
Today is Monday (Nov 4th)
The data shows the data from Nov 3 - Nov 9
Data from Nov 5 - Nov 9 is 0 (in the future)
It compares this number with the previous week (Oct 27 - Nov 2)
The previous week has full numbers, so the Trend (% change) is not going to be accurate until Nov 9th.
Instead, what I would like to do is:
Get numbers from previous 7 days, including today (Oct 28 - Nov 4)
Compare with 7 days prior to that (Oct 21 - Oct 27)
