Forum

Notifications
Clear all

Create a KPI dashboard

6 Posts
3 Users
0 Reactions
173 Views
(@ifathy)
Posts: 3
Active Member
Topic starter
 

Hi

I'm creating a KPI dashboard for my team (as attached), and I need to find a why where when i put the employee ID number it shows all his scores.

So I need to save the scores of each one and just switch between them using the ID !!

 

Thanks

Islam

 
Posted : 06/08/2020 6:54 am
(@purfleet)
Posts: 412
Reputable Member
 

Nothing attached mate.

dont forget to click upload

 
Posted : 06/08/2020 10:38 am
(@ifathy)
Posts: 3
Active Member
Topic starter
 

File added

 
Posted : 07/08/2020 12:46 am
(@mynda)
Posts: 4761
Member Admin
 

Hi Islam,

Thanks for sharing your file. If I'm understanding correctly, you want to use the PSD sheet as an input form that then copies the data to another sheet containing the results for all employees which you can then use for analysis?

If so, please refer to these options:

Microsoft Forms for gathering data

Forms (VBA)

I hope that points you in the right direction.

Mynda

 
Posted : 10/08/2020 12:04 am
(@ifathy)
Posts: 3
Active Member
Topic starter
 

Hi Mynda,

Thank you, but I am looking for something different.

I built my sheet so you can select the department name then you got a drop menu with the employee ID number when you select you got his/her data

you start get him a score for his performance.

What I need is after I finish the appraisal of the first employee I select the other one and start giving him his appraisal scores, and also keep all scores so I can switch between them when needed or to analyze the other all appraisals of the department?

Thanks

 
Posted : 10/08/2020 12:41 pm
(@mynda)
Posts: 4761
Member Admin
 

Hi Islam,

Please don't quote my reply again. It is directly above your reply so is not necessary. I've removed it from this post.

Thanks for clarifying your needs. The solution is still the same. You need to capture data entered and place it somewhere so that you can then enter the ratings for the next employee. In both Forms solutions linked to above you can provide the user with a list of items (employees) to choose from. I think the VBA based form will probably better suit your needs.

This requirement "and also keep all scores so I can switch between them when needed or to analyze the other all appraisals of the department?" will need to be done separately to the data entry form. It will query the data captured in the form so that you can analyse and compare it to the data being entered in the form. You could do this with a PivotTable and use the filters to select the employee you want to view.

Note: the data capture cannot be done with formulas because once you start to enter the next employee the previous employee's data will be lost.

Mynda

 
Posted : 10/08/2020 6:54 pm
Share: