topic Duration format conversion depending on value in App Development

Duration format conversion depending on value

ccastrillo — Sat, 16 Nov 2024 20:03:10 GMT

Hi,

I am trying to calculate the average duration of several incidents using aggr function. My expression works, showing days or HH:MM:SS depending on format selection (Duration or automatic). But what I want is automatic switch depeding on duration value. If duration is above 24h, I wish to show" DD days, hh hours, mm minutes", but if duration is less than a day, the format should be "hh hours: mm minutes".

The expression I am ussing is

avg(aggr(interval(date(Max(AuditDate))-date(Min(AuditDate)),'d hh:mm'),IncidentID))

Any ideas?

Many thnaks in advance,

César

Re: Duration format conversion depending on value

StarinieriG — Wed, 02 Oct 2019 13:25:21 GMT

Hi,

try with

avg(aggr(interval(date(Max(AuditDate))-date(Min(AuditDate)),

If(date(Max(AuditDate))-date(Min(AuditDate))>=1,'d hh:mm:ss','hh:mm:ss')

),IncidentID))

Re: Duration format conversion depending on value

ccastrillo — Tue, 15 Oct 2019 07:59:53 GMT

Thanks StarinieriG, it works!