Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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)
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)