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 an...
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!