KPI Average days in a specified status

[CA2]

Hi, I new to Qliksense desktop and I'd like some help please. I'd like to know how to create a formula to determine the average number of working days for items in a status of waiting user . How do I do that?

This average will be the KPI to assess against the standard of 10 working days to get a reply from the user, which if it is acceptable will move the item to the assessment stage.

Here's the sample data:

[lorenzoconforti]

Can you please do the following?

- create a table with ID as dimension and the following as measure: =Avg( aggr({<Status = {"Waiting user"}>} NetWorkDays(Created, Today()),ID))   ; does it show the net working days by ID?

- Post a picture of the Data Model Viewer; can an ID have more than 1 "Created"?

[Kushal_Chawda]

How you are trying it? can you send a screenshot  of Data and where you are trying?

[CA2]

Hi, I ended up tweaking the formula to remove the aggregation, which gave the correct result. Thanks so much for your help!