AGGR function - Average time for a service of sum time per user

[Touix]

Hello,

Here my data :

LOAD * INLINE [
    user               , date          , Time         ,Service       , Action 
    'user1'	,	 	 '28/11/2023' 	     , 100	        ,'Service1'    , 'Action1'
    'user3'	,	 	 '28/11/2023' 	     , 100	        ,'Service2'    , 'Action2'
	'user1'	,	 	 '27/11/2023'    	 , 30	     	,'Service1'    ,  'Action1'
    'user1'	,	     '27/11/2023' 	     , 60	      	,'Service1'    ,  'Action2'
    'user2'	,	 	 '27/11/2023' 	     , 110	     	,'Service1'    ,  'Action1'
    ];

I want to have for a service the average time for each  user of the service. 

Expected Result :

Service 1 --> 100 (average time of (average time of (sum time  per day , user, service) per service  ) 

Service 2 --> 100 (average time of (average time of (sum time  per day , user, service) per service  ) 

For Service 1 : 

first Step : Sum time per user , day and Service

27/11/2023 : (90  ,110 )
28/11/2023: 100

Second Step : Avegare per Service,per day :

Service 1 :

27/11/2023 : ( 90+110)/2  = 100
28/11/2020: 100

Last Step : Average of 2nd step :

Service 1 =  100 +100 /2 = 100

For Service 2

28/11/2023 : 100

I have lots of difficulty to do this.

Here the Qlikview with data. I would love you help.

Thank you all/