Avg Time

[#1]

Hello fellow Qlikicians

Looking for an aggr expression within a Text Box to convert seconds into an Avg time in 'D hh:mm' format.  Aggr by Topic.  I've attached a qvw.  The answer should be 0 00:24

Thank you!

[sunny_talwar · Accepted solution]

May be this:

=Interval(Time#(Floor(Avg(Aggr(Sum(Seconds)/Count(Topic)/60, Topic, ID, Seconds))), 'mm'), 'D hh:mm')

[#3]

Hi Sunny,

Yes.  Thank you so much!