+4From the below data I need,
1. Total Through put time by STAGES
(I have used standard KPI of Total Throughput Time formula and component Filter by STAGE, even though not getting required output)
2.Total Throughput time by TYPE
(I have used standard KPI of Total Throughput Time formula and component Filter by TYPE, even though not getting required output)
NOTE: Getting total time for the both scenarios after giving the Total throughput time and component filter
+14Hi @ugandhar.konap,
Instead of a component filter, try to use a CASE WHEN in your KPI. Not sure if this will give a different result but always worth a try.
If you want the Total throughput time use SUM as your aggregator. For example:
SUM(CASE WHEN
"CASE_TABLE_PO"."RESOURCE" = 'user_000'
THEN
CALC_THROUGHPUT(ALL_OCCURRENCE['Process Start'] TO ALL_OCCURRENCE['Process End'], REMAP_TIMESTAMPS("ACTIVITIES_TABLE_PO"."EVENT_TIME", DAYS))
WHEN
"CASE_TABLE_PO"."RESOURCE" = 'user_001'
THEN CALC_THROUGHPUT(ALL_OCCURRENCE['Process Start'] TO ALL_OCCURRENCE['Process End'], REMAP_TIMESTAMPS("ACTIVITIES_TABLE_PO"."EVENT_TIME", DAYS)) END)
of course replace the names in the example above with your own tables and columns.
Hopefully this helped you out.
Kind regards,
Sverre Klein
+4Thanks @sverre.klein11 for your reply.
I'm able to get the required output as per your suggestion and even DATEFIFF(DD, "Table_name"."Eventtime", ACTIVITY_LEAD("Table_name"."Eventtime", 1) is also working.
+14Thanks @sverre.klein11 for your reply.
I'm able to get the required output as per your suggestion and even DATEFIFF(DD, "Table_name"."Eventtime", ACTIVITY_LEAD("Table_name"."Eventtime", 1) is also working.
Great! Good to hear it helped you! 😁
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
