Jauge Qlick sense

[alexiadb]

Bonjour, 

Un petit peu d'aide avec une jauge svp : )

-------

j'ai des objectifs de recrutement  (REO)

des matricules sap pour le nouveaux employés (matricule_sap)

des agents de recrutements (gestionnaire)

je voudrai faire des jauges pour comparer les recrutements réalises par chaque gestionnaire.

----- 

merci!!!

sum(reo)/count(matricule_sap)*100

[JordyWegman]

Hi Alexia,

Can you maybe ask it in English? Then I can see if I can help.

Jordy

Climber

[alexiadb]

Thank you Jordy, : )

I need help with a gauge graphique please.

I m working on a recruitment app

I would like to make a gauge to show which agent met their objectives

i have a column for recruitment objectives (reo)

one for the recruitment agent (gestionnaire)

one for the sap ID of a new employee(matricule_sap)

 need to create an expression like that?

sum(reo) / count (matricule_sap) * 100

could you help me with creating this expression please?

----- 

merci !!!

[JordyWegman]

Can you maybe share an example of Excel data?

To specify the question a bit more:

• Do you want to know overall how many employees have met the objectives?
• Or do you want to know for each employee how he/she has met the objectives?

I'm trying to see if there are more objectives for 1 person. If so, this changes the formula a bit.

Jordy

Climber

[alexiadb]

Hi!

i would like know for each employee how he/she has met the objectives?

i have a column for:

Gestionnaire:

REO: hiring target 

REA:target realised

Thank you!!

[JordyWegman · Accepted solution]

If you then have a target you can do:

Sum( REA ) / Sum( REO )

You don't need the * 100 because you can format the number as a percentage.

Then you can filter on your employees and it will show the correct values. My assumption is, that the values are 0 and 1 here.If that is not the case, then this could be a solution:

Count( {$< REA -={"''"} >} REA ) / Count( REO )

This counts all the filled REAs and divide by the REO.

Jordy

Climber

[alexiadb]

Thank you so much Jordy!

[alexiadb]

Thank you so much Jordy!