Comparison Chart in Crystal Report

I am attempting to chart value changes over time.  I would like to see the numbers of items submitted over a particular time span (generated with a date parameter), grouped by year and by month.  My groups are correct as my counts seem accurate and I get the values that I want in a list form.  I want to visually display this in a chart, however.  Ideally, I want to display the side by side comparison of the months from each year next to each other so that I can see how the last year compared to this year.  My chart keeps giving my all of last year and then a space and then all of this year.  Is there a way that I can do this to achieve a side by side comparison?  A line graph would also be acceptable.  Thank you in advance for any assistance.
josslmpdAsked:
Who is Participating?
 
mlmccConnect With a Mentor Commented:
Create 2 formulas
SubmittedMonth
Month({SubmittedDate})

SubmittedYear
Year({SubmittedDate})

Create the chart using ONCHangeOf
SubmittedMonth then SubmittedYear

mlmcc
0
 
josslmpdAuthor Commented:
Thank you.  I thought I needed a new formula, but I wasn't sure what to do with it.
0
 
Karen ACommented:
I adapted the suggested formulas for my situation and they worked great.   Now, can you suggest a way to create a parameter to choose which "years" you wish to compare?
0
 
mlmccCommented:
WHat do you want the user to enter?

A single year and then select data from that year and the previous year?

Selection formula will be

{YourDateField} >= Date({?Year} - 1, 1, 1)
AND
{YourDateField} <= Date(Year,12,31)

You could also select 2 or more years.

mlmcc
0
All Courses

From novice to tech pro — start learning today.