How to calculate average time per each different WorkCenter in Qlik

[alespooletto]

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!

[Kushal_Chawda · Accepted solution]

@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')