Forum Discussion

RobSalaj's avatar
RobSalaj
Qrew Cadet
7 years ago

Looking to show ongoing year/months on a bar graph

I am looking to show a running monthly bar graph for billing. I need the X axis to show 2017 data by month and then continue, instead of repeating for 2018. Right now 2018 year data for January or mon...
Formulas and functions
reports and charts
Tables and fields
QuickBaseCoachD's avatar
QuickBaseCoachD
Qrew Captain
7 years ago
OK, easy,
so make a formula text field called [date] with a formula of

Date([Year from accounting system], [Month from accounting system], 1)

That will set each record to have a date field of the 1st of the month.  It does not matter which day of the month they areas you are grouping by month.

The use the date field on your X axis and get rid of the series.