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