Average duration in minute

[aresb]

Hi everyone,

let's suppose i have

How can i calculate the Average talk time in hh:mm:ss in QlikSense ? 

[Andrei_Cusnir · Accepted solution]

Hello,

Perhaps something like this will help:

1. I have the following dataset:

2. I have create a table with the following details:

1. Dimension: Agent
2. Measure: Sum([Duration (ss)])
3. Measure: Count([Duration (ss)])
4. Measure: Sum([Duration (ss)])/Count([Duration (ss)])
5. Measure: Interval(Sum([Duration (ss)])/Count([Duration (ss)])/86400)

3. Outcome is:

 

As you can see, it has properly counted 1 minute and 27 seconds.

I hope that this information was helpful. In case I have misunderstood the use case scenario, please elaborate in details by providing additional information. However, if it has helped you resolve the issue, addressed your concerns or at least pointed you in the right direction, please mark it as Accepted Solution to give further visibility to other community members. 
 

[aresb]

It works also with

Avg(interval(Interval#(Duration (ss)],'s'),'hh:mm:ss'))