Grouping information to understand the % total completion rate

alespooletto — Mon, 27 Jan 2025 10:49:45 GMT

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

Re: Grouping information to understand the % total completion rate

JandreKillianRIC — Mon, 27 Jan 2025 13:36:59 GMT

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

topic Grouping information to understand the % total completion rate in App Development

Grouping information to understand the % total completion rate

Re: Grouping information to understand the % total completion rate