Skip to main content
Question

Cases with Time Cycle above the Average TC

  • 16 March 2022
  • 1 reply
  • 0 views

Forum|alt.badge.img+7

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_OCCURRENCE['Process Start']  TO ALL_OCCURRENCE['Cla. Closed'],REMAP_TIMESTAMPS( "AT_CLAIM_L1"."_TIMESTAMP" ,  days))

>

AVG(CALC_THROUGHPUT(ALL_OCCURRENCE['Process Start']  TO ALL_OCCURRENCE['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!

1 reply

Hi @mercedes.mill√,

 

Save AVG(CALC_THROUGHPUT(ALL_OCCURRENCE['Process Start'] TO ALL_OCCURRENCE['Cla. Closed'],REMAP_TIMESTAMPS( "AT_CLAIM_L1"."_TIMESTAMP" , days))) as a variable with the format static value.

 

Then use the same PQL query:

 

CASE WHEN

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

>

<%=your_variable%>

then 'TC > AVG'

else 'TC <= AVG'

END