Set Analysis Expression using Interval

[ngosz4074]

Hello,

I'm trying to get a result using Set Analysis that would help filter my results using an Interval expression.  What is the best option to use when the result in the expression below is less > -32?

expression I'm using:

Interval( [PREV_RESULT_TIME] - [RESULT_TIME], 'hh:mm')

Thanks in advance

Neal

[miguelbraga]

Hey there,

Try this:

     Supose you have a field called IntervalP in script like this:

      Interval( [PREV_RESULT_TIME] - [RESULT_TIME], 'hh:mm') as IntervalP

     Then you can add a expression like this:

     =Aggr(

               {$<IntervalP = {'<32' }>}

               [your desired field goes here]

     )

     PS: Aggr -> function you must substitute to what you want

Hope this helps

Regards,

MB

[sunny_talwar]

less than -32 what? Hours or minutes or seconds? I think you need to provide more details if you would like us to help you better. May be provide a sample with expected output so that we can provide a working solution.

best,

Sunny

[ngosz4074]

I ended up switching the formula to an Aggr(Avg(RESULT_TIME)) with a dimension and it provides the result I am looking for.

Thanks for the help!