Date and Time dimensions

[nakuldev]

Hi Everyone,

I have a scenario where a Compressor status is Run/Stop along with Compressor name and date.

1) I need to find the number of days in between Run and Stop of that particular compressor.

2) number of days between first Stop and second stop for that particular compressor.

Please find the attached Qvw and source file for reference.

Thanks in advance

Nakul