Skip to main content
Question

Looking to show ongoing year/months on a bar graph

  • November 1, 2018
  • 0 replies
  • 29 views
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 month 1, appears side by side. To see an ongoing trend i need the X axis to continue. We are looking to combine year and month to allow the report to sort that way. However it looks like we may have to create two formula fields to accomplish this. The first to convert to text, then again to convert to a number. Just curious if there was a simpler way.
    This topic has been closed for replies.

    Do you have a date field?  Have you set the X axis to be the date, grouped by month,  and ensured that you do not have a "series" set?
    • RobSalaj
    • Author
    • Registered
    • November 1, 2018
    We do not have a date field per se. We integrated with our accounting software and pulling over the year and month that specific bills hit. we then are only showing monthly summaries in QuickBase. The X axis is currently a Month number (numeric). and yes i do have a series set for year (but could probably remove that if it will help)
    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.
    Terms & ConditionsAccessibility statement