Network Days based on another field

[CJR]

Hi, I'm relatively new to QlikSense and a complete novice, so apologies if this is a simple question...!

NetWorkDays([Start Date],[End Date])

I'm looking to create a measure to see how long it takes to respond to our customers based on the status of a case. The above works on a case by case basis which is ok, but I want the measure to just calculate for cases where the status is 'complete.'

I'm also trying to then calculate an overall average time as a KPI measure so I used Avg(NetWorkDays([Start Date],[End Date])) but it seems to be churning out a higher than expected number (could be a data issue though!)

Any help would be massively appreciated!

Thanks

Chris

[tm_burgers · Accepted solution]

If you have access to the Data Load script - I would add your NetWorkDays([Start Date],[End Date]) as a field - TimeToComplete

Then in your visualization you can use SetAnalysis with Avg

Avg( {< status =  {'complete'} >} TimeToComplete)