avg in time format

[soniasweety]

Hi All,

I am using below expression  for avg time   in KPI object

Avg({<Type={'Phone'}>}DurationSeconds)

so I want to show in  hh:mm:ss  format as result

can anyone suggest ?

]

[tresesco]

You can use formatting function around the expression like:

Time( Avg({<Type={'Phone'}>}DurationSeconds) , 'hh:mm:ss')

[soniasweety]

it is showing wrong result.

[tresesco]

Or, if your output of the expression comes in seconds, you may try like:

Time( Time#(Avg({<Type={'Phone'}>}DurationSeconds) ,'s') , 'hh:mm:ss')

[soniasweety]

my data base result :

but my qlik result

8348:23:09

[soniasweety]

this is showing null.

[tresesco]

Trying using floor(), like:

Time( Time#(Floor(Avg({<Type={'Phone'}>}DurationSeconds)) ,'s') , 'hh:mm:ss')

[tresesco · Accepted solution]

Another alternative:

Time(Avg({<Type={'Phone'}>}DurationSeconds)/86400 , 'hh:mm:ss')