I have a table that contains ticket details including the date the ticket was opened (jiraissue.CREATED) and the date the ticket was closed (jiraissue.RESOLUTIONDATE).
I would like to create a side by side bar chart that groups for each week the number of tickets opened, the number of tickets closed and the total number of tickets open at the beginning of each week (RT opened tickets - RT closed tickets...I think).
I have grouped the opened and closed tickets by week using the following formula.
DateTimeVar YourDate := {jiraissue.CREATED};
Numbervar WeekStart :=7;
Date (YourDate) - DayOfWeek (YourDate) + WeekStart
- (if DayOfWeek (YourDate) < WeekStart then 7)
My first issue is that I don't know what field to use for the "On change of" prompt when creating the chart. Do I need to use a formula to specify the date range I am interested in? If so, how is this done?
My second issue is that the formula I created with RTOpen - RTClosed is not showing up in the "Available fields" of the "Chart Expert".
I am using Crystal Reports 2008.
Thanks in advance for any assistance.
ZD