Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
every employee in our company has to make 50 suggestions for improvement (CIP) per year respectively one per week. Our goal is to make a line chart where we can see the cumulated goal and the total cumulated CIP`s per FTE or per Unit (e.g. Department Accounting). We want to consider new hires and/or employees that are leaving.
Based on the table below we have drawn the cart in Excel:
We have this data: name of employee, departement of employee, entry and leaving date, every CIP with the submission date(we can count) and the target of 50 CIP´s per year/FTE.
Example data:
Best regards,
Lisa
I have tested it on my local environment, the steps below are for you reference.
Sample table
Results
Regards,
Charlie Liao
Hi Charlie Liao,
thank´s for your help!
The column EmployeeCount don´t give me the right figure. Maybe because I have entry dates and leaving dates over years and not only for 2017? -> We have to combine week and year of the dates.
The result is a fixed chart. I can´t use e.g. a basic filtering by the employee because the measures have no connection to this informations. E.g. I want to drill down the chart to see how many CIP´s employee 1001 made in week 1.
Do you know a way to solve this?
Regards,
Lisa
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
100 | |
75 | |
73 | |
49 |
User | Count |
---|---|
145 | |
109 | |
109 | |
90 | |
64 |