Graph not showing properly

[Anonymous]

1. Two p5 entries are coming- Closed and Open but i want to show closed part.

2. P1 time taken to resolve 15:19 minutes but it is sahowing 1:01:16

Calculation-Total time taken to resolve p1 ticket(closed) /no of closed p1 ticket).

My bad- I am trying to mention about KPI resolution graph. If you change the expression of AVG resolution time then only you can get.

AVG resolution time-

=AGGR(SUM(DurationStefan)/count(TOTAL IF(UPPER(Status)='CLOSED',Severity)),P_Severity,Status)

[cjohnson]

Hi Suman,

Where are you seeing P1 = 1:01:16? I see 15:19 as you originally suggested:

Thanks,

Camile

[Anonymous]

My bad- I am trying to mention about KPI resolution graph. If you change the expression of AVG resolution time then only you can get.

AVG resolution time-

=AGGR(SUM(DurationStefan)/count(TOTAL IF(UPPER(Status)='CLOSED',Severity)),P_Severity,Status)

calculation should be- Total time taken to resolve p1 ticket(closed) /no of closed p1 ticket).

[Anonymous]

Hello please help

[Anonymous]

I asked for a solution but i am ot getting any reply yet. It seems qlikview is quite complicated.

[cjohnson]

Hi Suman,

How about just changing your expression to the following:

SUM({<Status = {'Closed'}>} DurationStefan)/COUNT({<Status = {'Closed'}>}Severity)

Does that give you the desired result?

Or if it's truly the total severity you are looking for (as the numerator) then change it to the following:

SUM({<Status = {'Closed'}>}TOTAL <P_Severity> DurationStefan)/COUNT({<Status = {'Closed'}>}Severity)

Can you give examples of actual results you are expecting?

Thanks,

Camile

[Anonymous]

many thanks for your help.

Apprecite it.

I have sent you attached jpeg file. In the top part i have mentioned the output which i want to display.

[MarcoWedel]

‌maybe helpfull:

Its not about the answer, rather it’s about the question…

QlikCommunity Tip: How to get answers to your post?

Qlik Community Tip: Posting Successful Discussion Threads

regards

Marco