Bar Graph Number of Cases Yesterday and Same Day Last Year

  • 0
  • 1
  • Question
  • Updated 3 years ago
  • Answered

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.

Any thoughts?


Photo of Vincent


  • 0 Points

Posted 3 years ago

  • 0
  • 1
Photo of Eric


  • 40 Points
If you create a formula date field that is AdjustYear([DateCaseOpened],1) so that dates from last year will be calculated into this year's timeframe. Then you can have a report with two filters that say "FormulaDateField is equal to yesterday" and the second as "DateCaseOpened is equal to yesterday" and with both of those there you should be able to easily combine the two values together into one report.