Hi, I am trying to run one query that will show both this year's and last year's data for a given week (Mon - Sun). While the current year's data shows up for the dates, it is not showing the same data for the same dates one year prior. Is there a way for this to display in the same query? My preference is to have it be the actual value and not percentage differences.
Thank you in advance for your help!
It should show up as an additional column next to the current values - I build a similar query to what you had in the screenshot and it should look like this:
It's possible there's some issue with the query settings. You can delete the values and the old query itself, and then rebuild it fresh to see if it adds that second column. If that doesn't help, please let us know.
It worked with no issues! Thank you!