topic Re: Interval Issue - Not working when grouping numbers in App Development

Interval Issue - Not working when grouping numbers

c_latham — Sat, 16 Nov 2024 19:10:58 GMT

Hi All,

I have a table with the following in formation:

Delay	Duration (seconds)
Break	900
Break	1800
Bad Weather	240
Shift Change	900

I am using this interval function to convert Duration into hh:mm - =Interval(Interval#([Duration (seconds)], 's'), 'hh:mm')

However, when i remove Duration (seconds) column from the table chart I expect Break to show as a line with an interval of '00:45' but i just get a blank line. The other 2 'non grouped' columns work as expected.

Any help would be appreciated.

Thanks!

Re: Interval Issue - Not working when grouping numbers

lorenzoconforti — Tue, 04 Feb 2020 12:05:45 GMT

this should work:

Interval(Interval#(sum([Duration (seconds)]), 's'), 'hh:mm')

Re: Interval Issue - Not working when grouping numbers

Vegar — Tue, 04 Feb 2020 12:10:11 GMT

Your expression looks fine.

Maybe there is something with your source data? Have you tried to trim() the field to get rid of white spaces in the begining and end of the field.