Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
I need to find the number of ID's within the SLA times (count )
Any chance that you could upload your source data: "Multimedia Data.xlsx"?
Andy
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)