Skip to main content
Question

Formula to Show Line Chart for 2 years history

  • July 10, 2019
  • 0 replies
  • 20 views
Forum|alt.badge.img+11
I am trying to create a line chart in a snapshot table that will show (2) years of history.  Per the screenshot I am trying to build a formula for the report to give me January 1st from 2 years ago and use that as my filter on my report.  This way it will only look at data from 2 years ago by default and create my line chart.  But I am getting an error in my formula saying I cannot use a minus AND I dont know how to reference that formula in my filtering for my chart...

    Typically, you would have a series of filters like

    where ANY of the following

    date is during the current year
    date is during her previous 2 years.

    That way you get complete years.

    You can also use Fiscal year if your company uses a non January fiscal year and you set your app to know that.

    Terms & ConditionsAccessibility statement