Hi, I've been trying to get a Line Chart developed showing the number of tickets for a system that were opened, closed or are still open (backlogged) over weekly time periods.
I've been using the following fields to try to do this:
Request_Number (1,2,3,...)
Submission_Date - (timestamp)
Close_Date (timestamp)
Request_Status (Open, In_Progress, Closed, etc..)
I first tried evaluating the submission_date as the 'On Change of' (grouped weekly) in the chart expert however it gave me a correct count for opened tickets and not for closed tickets. I then tried using the closed_date and it gave me the correct count for closed tickets but opened tickets were incorrect.
I then did a join on the dates to get a list of all the timestamps I wanted to compare on and it still gives me the wrong closed dates.
Has anyone who's done something like this provide any help? If you could help with the forumlas that would be great but I'd also like to know how the cryatal reports charts engine is comparing the 'On Change of' dates to what I have.
Thanks,
Joe
I've been using the following fields to try to do this:
Request_Number (1,2,3,...)
Submission_Date - (timestamp)
Close_Date (timestamp)
Request_Status (Open, In_Progress, Closed, etc..)
I first tried evaluating the submission_date as the 'On Change of' (grouped weekly) in the chart expert however it gave me a correct count for opened tickets and not for closed tickets. I then tried using the closed_date and it gave me the correct count for closed tickets but opened tickets were incorrect.
I then did a join on the dates to get a list of all the timestamps I wanted to compare on and it still gives me the wrong closed dates.
Has anyone who's done something like this provide any help? If you could help with the forumlas that would be great but I'd also like to know how the cryatal reports charts engine is comparing the 'On Change of' dates to what I have.
Thanks,
Joe
