Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
With help of community i have near about completed the application.
Two things are still pending-
1. Requesting you to check whi P1 is not coming in the KPI graph.
2. Two p5 entries are coming- Closed and Open but i want to show closed part.
Please help.
Regards
Anutosh
I have added the application
Hi Suman,
I have attached the file, there is no entry for P1 as its Status value is not 'CLOSED'.
Hope it helps you.
Suman Dhar wrote: 1. Requesting you to check whi P1 is not coming in the KPI graph. Because that has zero value and zero value is supressed. You can change the setting in the presentation tab to make it appear. 2. Two p5 entries are coming- Closed and Open but i want to show closed part. Include the 'Closed' condition in the first part of your expression as well, like: =AGGR(SUM(IF(UPPER(Status)='CLOSED',DurationStefan))/count(TOTAL IF(UPPER(Status='CLOSED',Severity)),P_Severity,Status)
Suman Dhar wrote:
Because that has zero value and zero value is supressed. You can change the setting in the presentation tab to make it appear.
Include the 'Closed' condition in the first part of your expression as well, like:
Answer: This is due to supress zero values
Thanks for your reply-
May be i am not expressed properly. Result of your application is not showing properly.
I want-
Severity KPI Time(HRS) AVG resolution time(HRS)
-----------------------------------------------------------------
P1 3 2.25 (Calculation- Total time taken to resolve p1 ticket/no of p1 ticket). We need to consider only closed ticket
P2 4 3.29
P3 8 5.65
P4 NO SLA 150
P5 NO SLA 129
If I update the sheet P1 with closed status still it is not coming.If I uncheck the zero values then it breaks into multiple rows.
This code is not working
Please help
I have checked avg is not coming properly in my graph. I have mentioed the calculation.
As per my example-
P1 time taken to resolve 15:19 minutes but it is sahowing 1:01:16
please give me soime suggestion
