Forum Discussion

IvanWeiss's avatar
IvanWeiss
Qrew Captain
6 years ago

Formula to Show Line Chart for 2 years history

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...
reports and charts
  • QuickBaseCoachD's avatar
    QuickBaseCoachD
    Qrew Captain
    6 years ago
    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.

    • IvanWeiss's avatar
      IvanWeiss
      Qrew Captain
      6 years ago
      Ah that did it!  Thanks so much.  I am goign to do that on my table import this way it only pulls in data for the last group of years and I can report on all of that data.

      Thanks so much as always!