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/
