Hello

I have the following problem:

We have the AVG time cycle for a set of case and we want to obtain the % of cases with TC below de average and above average.

I tried to do it in this way:

CASE WHEN

CALC_THROUGHPUT(ALL_OCCURRENCEN'Process Start']  TO ALL_OCCURRENCEE'Cla. Closed'],REMAP_TIMESTAMPS( "AT_CLAIM_L1"."_TIMESTAMP" ,  days))

>

AVG(CALC_THROUGHPUT(ALL_OCCURRENCER'Process Start']  TO ALL_OCCURRENCER'Cla. Closed'],REMAP_TIMESTAMPS( "AT_CLAIM_L1"."_TIMESTAMP" ,  days)))

then 'TC > AVG'

else 'TC <= AVG'

END

but I get the following message:

The aggregation function AVG cannot be used together with a dimension function input. Please check that there are no aggregations and dimensions used together as function inputs.

Which would be the correct way to have the information we need?

Thanks!