Hi @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_OCCURRENCEN'Process Start'] TO ALL_OCCURRENCEN'Process End'], REMAP_TIMESTAMPS("ACTIVITIES_TABLE_PO"."EVENT_TIME", DAYS))

WHEN

"CASE_TABLE_PO"."RESOURCE" = 'user_001'

THEN CALC_THROUGHPUT(ALL_OCCURRENCEN'Process Start'] TO ALL_OCCURRENCEN'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

Thanks @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! 😁