Hi Lukas,

I think the biggest problem will be the visibility of the bar chart because based on how many different Activities you want to display within your bar chart and for each activity showing the different numbers of rework might flood the whole chart.

When you say it can only be between 0-5 loops you can use a logic like this as Dimension:

CASE WHEN PU_COUNT("BSEG","_CEL_AP_ACTIVITIES"."ACTIVITY_EN") = 1 THEN '1'

WHEN PU_COUNT("BSEG","_CEL_AP_ACTIVITIES"."ACTIVITY_EN") = 2 THEN '2'

WHEN PU_COUNT("BSEG","_CEL_AP_ACTIVITIES"."ACTIVITY_EN") = 3 THEN '3'

WHEN PU_COUNT("BSEG","_CEL_AP_ACTIVITIES"."ACTIVITY_EN") = 4 THEN '4'

WHEN PU_COUNT("BSEG","_CEL_AP_ACTIVITIES"."ACTIVITY_EN") = 5 THEN '5'

ELSE '0' END

And a Activity or Case Count as KPI:

COUNT("_CEL_AP_ACTIVITIES"."ACTIVITY_EN")

This will show you a bar chart with x-axis =  number of loops and y-axis = frequency of occurrence

But it would make sense to combine this chart with a drop down button where someone needs to select an activity first - same way as it is done in rework selection.

BR

Dennis

Hi Dennis,

Thanks for your answer and help!

I have adopted your PQL statement. I have used the domain table because I am only using one Excel file as an event log and there are no other tables.

You mentioned visibility is an issue due to the number of activities. I would like to display only one activity, namely Activity 'E', the last one in the loop see image named Excel.

CASE WHEN PU_COUNT(DOMAIN_TABLE ( "abc_Sheet1"."AKTIVITÄT"),"abc_Sheet1"."AKTIVITÄT") = 1 THEN '1'

WHEN PU_COUNT(DOMAIN_TABLE ( "abc_Sheet1"."AKTIVITÄT"),"abc_Sheet1"."AKTIVITÄT") = 2 THEN '2'

WHEN PU_COUNT(DOMAIN_TABLE ( "abc_Sheet1"."AKTIVITÄT"),"abc_Sheet1"."AKTIVITÄT") = 3 THEN '3'

WHEN PU_COUNT(DOMAIN_TABLE ( "abc_Sheet1"."AKTIVITÄT"),"abc_Sheet1"."AKTIVITÄT") = 4 THEN '4'

WHEN PU_COUNT(DOMAIN_TABLE ( "abc_Sheet1"."AKTIVITÄT"),"abc_Sheet1"."AKTIVITÄT") = 5 THEN '5'

ELSE '0' END

The excel file (Excel) and DFG (DFG) looks as follows:

The bar chart looks as follows with the code:

The bar chart indicates that there is only the possibility of no loop iteration, which occurs 251 times, even though there are only 100 cases.

However, the rework selection bar chart for the aktivity "E" looks as follows and the total occurrences also add up to the 100 case IDs.

Thanks for your help and have a nice weekend!

Best regards

Lukas😃

Hello everyone,

I created the exact same bar chart from rework selection as component with the following dimension and KPI:

Dimension: CALC_REWORK ( "columnTable"."AKTIVITÄT" = 'E' )

KPI: COUNT_TABLE("abc_Sheet1_CASES")

Best regards

Lukas

Hi Lukas,

good solution.

Thanks for letting us know.

BR

Dennis