josslmpd
asked on
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.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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?
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
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
ASKER