How to calculate average time per each different WorkCenter in Qlik

alespooletto — Wed, 18 Sep 2024 09:56:22 GMT

Hello, I have the following table:

Each SFC is associated with 2 time stamps:

- Start

- Complete

And each of these 2 steps is done in a single WorkCenter only.

I need to obtain a table that shows me the average time grouped by SFC for each of those different work centers. Is there a way to do this in Qlik?

It shouldn't look like this graph, but it's just to give an idea of how I would like it represented after

Thank you!

Re: How to calculate average time per each different WorkCenter in Qlik

Kushal_Chawda — Wed, 18 Sep 2024 10:27:42 GMT

@alespooletto Assuming your Date format is properly formatted (not text) with work centre as dimension, try below measure

=time(Avg(aggr(Interval(Only({<Activity={'COMPLETE'}>}Date)-Only({<Activity={'START'}>}Date),'hh:mm:ss'),WorkCenter,MainSFC)),'hh:mm:ss')