I'm trying to create a bar chart by month. But I only want the last 3 months of data to show. Is that possible?

  • 0
  • 1
  • Question
  • Updated 1 year ago
  • Answered
My bar chart shows all months for the past 4 year. I would only like to see the last 3 months. How can I do that?
Photo of Joey Lopez

Joey Lopez

  • 70 Points

Posted 1 year ago

  • 0
  • 1
You would need to add some filters to your chart report.

If you want to include the current month in the 3 months, use the pic below:



If you do not want to include the current month and only show the previous 3 months, use this:

Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 51,436 Points 50k badge 2x thumb
No problem.  Add a filter to you report for which dates to include.

Like 

where [my date field] is during the previous 3 months



or perhaps

where [my date field] is on or after 90 days in the past.