Hi, I'm sure this is fairly simple. I have a load script for my GUI that looks like this:
Directory;
LOAD [Assyst Operator ID],
[Resolver Group],
[Company ID],
[Incident ID],
[Assyst Ref No],
[Date Call logged],
[Days since logged],
[Affected User],
[User Referer],
[Affected User Contact No],
Description,
[Callback Remark],
[Call back necessary],
[Call back date],
[Breach Date],
[Date of action resolve],
[Days left over before Breached],
[Close Date],
[Company Name],
[Assyst Section Name],
[Assyst Operator],
[Assyst User Name]
FROM
Data\Incident.qvd
(qvd);
LOAD [Incident ID],
DaysOpen,
Daysloggedgroup
FROM
Data\Groups.qvd
(qvd);
This system is used to monitor call pick ups, however the problem is everytime something changes in the calls details a new row is added, therefore in order to get an accurate count of the number of calls on the go at any one time I need to perform a distinct on just the Incident ID, so instead of there being 10 for incident 549536 with all the rows showing the various details I just get the one row.
Or is there an easy way for me to show it in my graph, at the moment I am using the command COUNT (Incident ID) , this returns some 1500 records for one day when really there are only about 150 due to adding a row for every line of detail changed. Any ideas for those two?
