Grouping information to understand the % total completion rate

[alespooletto]

Hello, I have a table of data and I would like to create qlik measures to obtain, in different tables, the percentages of training hours completed in respect to the ones that are necessary. 

mc_competence_description_group	mc_competence_description	Right(OperatorName,4)	Controllo Formazione	mc_log_ActualTrainingHours	mc_competence_NeededTrainingHours	mc_log_PlannedTrainingHours
Abilitazione   attività di supporto	Abilitazione mansione Kanban	vide	OK	08:00:00	02:00:00	0
Abilitazione   attività di supporto	Abilitazione mansione picking   motori	vide	OK	08:00:00	02:00:00	0
Abilitazione   attività di supporto	Abilitazione mansione picking   riduttori	vide	OK	08:00:00	02:00:00	0
Abilitazione   attività di supporto	Abilitazione postazione Hang Up	vide	OK	08:00:00	02:00:00	0
Abilitazione   cellula 21	Formazione prodotto R37	vide	OK	08:00:00	08:00:00	1
Abilitazione   cellula 21	Formazione prodotto S37	vide	OK	08:00:00	08:00:00	1
Abilitazione   cellula 31	Formazione prodotto S47	vide	OK	08:00:00	08:00:00	1
Abilitazione   cellula 31	Formazione prodotto S57	vide	OK	08:00:00	08:00:00	1
Abilitazione   cellula 31	Formazione prodotto S47	vide	Planned	05:00:00	08:00:00	1
Abilitazione   cellula 31	Formazione prodotto S57	vide	Planned	05:00:00	08:00:00	1

This is an extract, but if more data is needed I can provide it. What I would like to see is something like this: 

OperatorName	Actual Hour	Needed Hours	Completion
simo	80	100	80%
vide	120	100	120%

This should take into account the different times needed for the different rows... thanks in advance, it's a bit complicated for me to do such an aggregated measure of many things

[JandreKillianRIC · Accepted solution]

Hi @alespooletto 

Based on the data you provided this is my result 

Actual Training Hours 

Interval(Sum(mc_log_ActualTrainingHours), 'hh:mm')

Needed Training Hours 

Interval(Sum(mc_competence_NeededTrainingHours), 'hh:mm')

Completion %

Sum(mc_log_ActualTrainingHours) / Sum(mc_competence_NeededTrainingHours)

and then just change the Number format to %. 

Regards Jandre