topic Re: Formatting Class with Time Interval in App Development

Formatting Class with Time Interval

dana — Fri, 28 Jul 2023 17:25:50 GMT

Hi People,

I want to display buckets of durations in a histogram, with an interval of 15 minutes:

=Class(Incident_FirstUpdate_Hours, Interval('00:15','hh:mm'))

But the result is in decimal

I tried to convert it to interval, but it didn't display it as a bucket:

=Interval(Class(Incident_FirstUpdate_Hours, Interval('00:15','hh:mm')),'hh:mm')

How do I convert it to Interval?

Thanks!

Re: Formatting Class with Time Interval

justISO — Mon, 31 Jul 2023 07:35:20 GMT

Hi, you can try to replace/convert num parts to time, f.e. you have your class expression to separate your Incident_FirstUpdate_Hours between 15 min buckets:

class(Incident_FirstUpdate_Hours, 1/24/4)

and from this class 'string' you can create new one with minutes with something like this:

time(subfield(class(Incident_FirstUpdate_Hours, 1/24/4),'<=',1),'hh:mm') & ' <= x < '& time(subfield(class(Incident_FirstUpdate_Hours, 1/24/4),'<',3),'hh:mm')

Re: Formatting Class with Time Interval

dana — Mon, 31 Jul 2023 15:10:38 GMT

Very nice!

Thanks!