Trying to get a bar graph to show side by side the total number of cases yesterday and the same day last year. So far, QB is just saying that it cannot load the legend items and the filter is only grabbing yesterday's date.
I created a formula field called "ThisDateLastYear" which takes "DateCaseOpened" and is AdjustYear(DateCaseOpened, -1).
For the Category Labels and Series, I have DateCaseOpened grouped by Year. (I've tried Equal Values and Day and can't get it to show any different.)
I have the filter set to DateCallOpened is equal to yesterday and DateCallOpened is equal to the date in the field ThisDateLastYear.
Have tried hard coding the dates, but it will always show just 2016 and not 2015.