Discussions

Expand all | Collapse all

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?

  • 1.  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?

    Top
    Contributor
    Posted 06-01-2017 18:38
    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?


  • 2.  RE: 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?

    Bronze
    Contributor
    Posted 06-01-2017 19:00
    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:



  • 3.  RE: 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?

    Posted 06-01-2017 19:01
    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.