SLA times in Qlikview

[#1]

Hi Community

Hope you are patient with my daily questions , Can you Please assist me on how i can fulfil this requirement ?

I attached the Qvw file with data .

-----Work out which ones are within SLA

SLA Time = (Actual end time of work item) - WI_CT (Creation Time)

If SLA Time < 60min then WithinSLA = “True”

If SLA Time > 60min then WithinSLA = “False”

% Within SLA = sum ID where WithinSLA = “True” / Today Completed

% Outside SLA = sum ID where WithinSLA = “False” / Today Completed

[#2]

I need to find the number of ID's within the SLA times (count )

[awhitfield]

Any chance that you could upload your source data: "Multimedia Data.xlsx"?

Andy

[Gysbert_Wassenaar]

Within SLA Time: =count({<ID={'= [Actual end time of work item] - [Create Time] < 1/24'}>}distinct ID)

Outside SLA Time: =count({<ID={'= [Actual end time of work item] - [Create Time] >= 1/24'}>}distinct ID)