How to exclude date based on aggr function

Marcushenriquesk — Tue, 22 Feb 2022 15:12:32 GMT

=avg(aggr((RUN_DATE_TIME-RECEIVED_DATE_TIME)*24,ACC_ID))

I am trying to use set analysis in this function to exclude all ACC_IDs that have a run_date_time>= Received_date_time

{<[RUN_DATE_TIME]={'=[RUN_DATE_TIME]>=[RECEIVED_DATE_TIME]'}>}

I have tried using this before the aggr and after the aggr but it does not work as intended.

Re: How to exclude date based on aggr function

hic — Tue, 22 Feb 2022 16:48:29 GMT

You need double quotes for searches.

Avg({<ACC_ID-={"=[RUN_DATE_TIME]>=[RECEIVED_DATE_TIME]"}>} aggr((RUN_DATE_TIME-RECEIVED_DATE_TIME)*24,ACC_ID))