multiple Line Chart comparing year to year
I would like to create a line chart that shows year to year comparison.....see attached image....how can I do this?? thanks
Forum Discussion
- 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.
- Mark, thanks for the advice. Question: Will I also need to create a Month field for the x axis?
- 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.
- 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.
- Ivan, can you explain where in my responses above you are getting stuck?
- I dont want "all" of the years. I only want to show data from 2 years prior on.
- 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.
