Hello - I'm trying to compare one period of time to another period of time and show the difference between the two. Ideally the spreadsheet would show
- Last months goal completions
- Current month's goal completions
- Exact value difference between the two
I'm currently displaying the current month and previous month values and calculating the change in another spreadsheet (image attached) but wanted to know if you could just auto calculate it via a query.
There is a built-in comparison setting but it doesn't return the value for the prior month's data along with the absolute change (you only get one or the other). So it doesn't do exactly what asked but maybe it gets you closer?