Print Page | Close Window

Calculating open calls

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Technical Questions
Forum Discription: Formulas, charting data, Crystal syntax, etc.
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=15483
Printed Date: 28 May 2024 at 5:11am


Topic: Calculating open calls
Posted By: AndyLeates
Subject: Calculating open calls
Date Posted: 30 Jan 2012 at 4:20am
Afternoon
 
I'm creating a report based around the number of open tickets on our Service Desk.
 
Working out how many tickets are open is quite obviously easy. However, I'm trying to get my head round how to calculate how many tickets were open at a given point in time, say a week or a month ago.
 
Is this possible?
 
Regards
 
Andy


Replies:
Posted By: sgtjim
Date Posted: 30 Jan 2012 at 4:32am
This depends on how the data is stored. If there is a historical data that records the ticket status and time as their statues change then you can probably obtain the data. If the latest status is the only one in the table then, it will be difficult to 'run' a report and obtain the data you are looking for.

If the historical data is not stored, then an option is to run the report every "time_frame" and put it into another data base or spread sheet to store historical data.

Posted By: AndyLeates
Date Posted: 30 Jan 2012 at 4:35am
Thanks, will ask the application vendor is historical statuses are stored and go from there.
 
Regards
 
Andy


Print Page | Close Window