Separating data from one column into multiple columns

[#1]

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

[#2 · Accepted solution]

Hi Ben,

see this example using INTERVALMATCH.

Good luck!

Rainer

[#3]

or this one using CLASS()

Rainer