Calculate Count and average based on user selected values

pani — Sat, 16 Nov 2024 03:36:55 GMT

Can you help on below issue

I have table of Task with field names
Case Id,
Status,
Created date,
Updated Date,
Resolved date,
Reload Date,

I would like to put below solution on Straight table like Status, number of cases and Avg days,

Status is categarized Backlog, Ready for Squad, In Process, Done

These status can Changes every day, Twice in a day, May remain same( In case of remain same, it will not repeat, untill data status changes)

We need to caculate age of every status means

If task is in Backlog on 1st May and status changes to In Process on 6 May, The Age of backlog will be 6. same way we need to caculate others staatus age also.

Filers should have From date and To date (From date and To date derived from reload date)

Above Calculatiuon Should be dynamic based on In date interval selected by User

Also once the status is changed for a case, the case should be counted only once in the new status and should ignore in the old status.

Thank you

Re: Calculate Count and average based on user selected values

mrtinsjoao — Wed, 22 May 2019 20:43:55 GMT

Great Day,
You can Store every load the fields that you want to monitorate. I think that solution is the most easy.
Thnks !
😉

topic Re: Calculate Count and average based on user selected values in QlikView

Calculate Count and average based on user selected values

Re: Calculate Count and average based on user selected values