@adamsmith47 if you don't want to do the mvexpand, then do the comparison before you do the aggregation or, if you are using Splunk 8, you can use mvmap, see the last two lines of this example | makeresults
| eval n=mvrange(1,4)
| mvexpand n
| eval _time = now() - (n * 1000)
| eval mv_epoch = mvrange(1,6)
| mvexpand mv_epoch
| eval mv_epoch = _time - (random() % 4 + 29) * 86400
| eval days=(_time-mv_epoch)/86400
| eval t=strftime(mv_epoch, "%F %T")
| stats values(mv_epoch) AS mv_epoch values(t) as t values(days) as days BY _time
| eval e=relative_time(_time, "-30d@d")
| eval test=if(isnull(mvmap(mv_epoch, if(e<=mv_epoch AND mv_epoch<=_time, 1, null()))),"no", "yes")
... View more