Hours to Day and Hour Format Conversion

[Akhil1993]

I have a KPI called call time and the value is coming like 1 04:03:25.

I need this in a format, 1 Day 04 hour 03 minute 25 sec.

The measure I am using is Aggr(avg(Distinct (Time(ConvDuration/86400,'hh:mm:ss'))),Calls_Key)

where ConvDuration is my time filed.

Calls_Key is the filed used for grouping.

Please help me to solve this. Appreciate your help. Thank you

[salonicdk28]

Hi, Try the below expression once

First convert into number and then distribute it respectively as per d h mm ss

= Replace(Replace(Replace(Replace(Interval(Interval(Datetime1*86400,'dd hh:mm:ss')/24/60/60,'dd U hh V mm X ss Z'),'U', 'Day'),'V', 'Hour'),'X','minute'),'Z', 'sec')

I am getting the result as desired , please see the below screenshot -