Calculate avg time

[Anonymous]

Good evening,

I'm quite new to Qlik Sense and Google seems to be giving me lots of different search results so I'm gonna try to ask my question here;

I'm creating an app to display the daily phone usage in our company.
We get a list from average ringing times (contains data in HH:MM:SS format).
When I want to create an average of that list using the AVG(RowA) function, I get a wrong result.

This is the data from one of the rows (RowA):

00:00:58
00:00:00
00:00:00
00:00:00
00:00:00
00:00:00
00:00:00
00:00:00
00:00:00
00:02:12

Qlik Sense displays 00:00:19 as an average time while in fact the avg time is 00:01:35 .

Can anyone help me to find the correct expression I need to display the correct average time?

Thank you very much!

[sunny_talwar]

Try this may be

Avg({<RowA = {">0"}>}RowA)

[Anonymous]

---

@sunny_talwar wrote:

Try this may be

Avg({<RowA = {">0"}>}RowA)

---

OMG that's it, it works.

Thank you SO much! 🙂

[sunny_talwar]

Awesome 🙂