Question about using maxover on datetimes

[linchoff]

I’m trying to use a calculated field to return the maximum datetime where the metric “Parts” > 0, and where the datetime is less than the datetime “LunchTime”. Is there any expression that might do this?

[Wakana]

hi @linchoff,

Can you try with max() and ifelse() like the following?

max(ifelse(Parts>0 and Extract('HH',datetime)<12 ,datetime, null),[])

kind reagrds,
Wakana

[linchoff]

@linchoff

a calculated field to return the maximum datetime where the metric “Parts” > 0, and where the datetime is less than the datetime “LunchTime”. Is ther

This worked perfectly! Thank you so much for your assistance!!!