Quick Base Discussions

Expand all | Collapse all

multiple Line Chart comparing year to year

  • 1.  multiple Line Chart comparing year to year

    Posted 10-13-2016 15:32
    I would like to create a line chart that shows year to year comparison.....see attached image....how can I do this?? thanks



  • 2.  RE: multiple Line Chart comparing year to year

    Posted 10-13-2016 15:42
    I suggest making a field called Year which calculates the Year.  It should be possible then to have the "series" be the Year.  I did not test that so let me know if that does or does not work.


  • 3.  RE: multiple Line Chart comparing year to year

    Posted 10-13-2016 18:24
    Mark, thanks for the advice. Question: Will I also need to create a Month field for the x axis?


  • 4.  RE: multiple Line Chart comparing year to year

    Posted 10-13-2016 20:02
    Actually, yes you will.  Initially make a numeric field with a formula of Month([my date field]) to test that.  It will read as numbers as opposed to words.  if you get it working and the number months bother you post back here.


  • 5.  RE: multiple Line Chart comparing year to year

    Posted 07-10-2019 10:34
    I know this is an old thread but how did you get the report to consistently start in January several years back?  I am trying to do something like this and have a snapshot table.  I only want the last 2 years of history plus my current year.  But I always want it to start in January.  So, for example, today is July 10th 2019.  I want my graph to start January 2017 through today.


  • 6.  RE: multiple Line Chart comparing year to year

    Posted 07-10-2019 11:32
    Ivan, can you explain where in my responses above you are getting stuck?


  • 7.  RE: multiple Line Chart comparing year to year

    Posted 07-10-2019 12:08
    I dont want "all" of the years.  I only want to show data from 2 years prior on.


  • 8.  RE: multiple Line Chart comparing year to year

    Posted 07-10-2019 12:19
    You can filter where any of the following

    Date is during the current year
    Date is during the previous 2 years.

    "Is during� is a built in filter choice.