Cognos Time Split

[thecognos]

Hi Gurus,

I have attributes namely count of execution scripts, start time and End time. I need to draw a graph in cognos to show how many scripts ran for every 5 minutes time interval. I basiclly want to know how to split the timing for each five minutes. Please help me in this.

Thanks

 

[blom0344]

Do you mean that you want to score = 1 for every script that has run for at least a second between , say , 00:00 and 00:05?

We need more information I guess to get this solved.
My first reaction would be to introduce a special time table to get this solved

Ties Blom

 

[thecognos]

HI blom0344 ,
Yes, you are corrcet i want to split it as 00:00 and 00:05. Pease help me with this.

 

[blom0344]

How does the data look like? Can you show us a sample?

Ties Blom