Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi, I am creating a system to look at the response times for our support systems, I have managed to calculate a variable for Days since called logged, now what I want to be able to do is split this data up into 6 different types, 1 day old, 2 days old, 3 days old, 4 days old, 5 days old and 6 days plus. What is the best way to do it?
At the moment I am considering using:
Load * From where Days since logged = '1'
STORE INTO TEMP/1.qvd;
Then repeating the same for 2,3,4,5 and 6+
Then I was intending loading them all and concatening them together. However I was speaking to someone the other day who said there was a far easier way to do this sort of load rather than creating a new temporary qvd for each of the fields I am interested in. Can anyone help explain what this is and possibly provide an example qvd? Sorry this is a bit vague.
Cheers
Ben
Hi Ben,
see this example using INTERVALMATCH.
Good luck!
Rainer
or this one using CLASS()
Rainer