Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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
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!