I’m trying to put together a period over period comparison where I would like to compare the count of a field to date for this month (eg. count of sales to date for May) versus the count of sales to date in May of last year.
but when I plop it into a table it shows me what looks like this month vs this month last year differences that are for the whole month and not “to date”. That is, I want to compare sales from May 1st, 2022 to May 22, 2022 to sales from May 1st, 2023 to May 22, 2023. Furthermore, if I put a filter on the sales_date field to start after May 1, 2023, the comparison ceases to work because of what looks like an inability to grab data from before May 1, 2023.
How would I go about achieving a “this month to date vs this month to date last year” comparison?