Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi team,
I have got a requirement which has 5 columns in it(something similar to like this) namely employee, manager, start date , end date and sales value and the employees are working under different managers in one calendar year. How do we display it in the form of pie-chart with the change of an employee from one manager to another reflected with the end date in the pie-chart?
Any help on it will be appreciated.
Thanks!
Hi @jbhavesh077,
Please share some sample data and clarify corresponding desired results.
Best Regards,
Qiuyun Yu
Hi Qiuyun,
Please find below the sample data for which I am looking to plot a pie chart
Employee | Manager | Start date | End date | No of Sales Unit |
John | Rossy | 1/1/2018 | 3/31/2018 | 10 |
Steve | Smith | 1/1/2018 | 7/31/2018 | 12 |
Bill | Sandra | 1/1/2018 | 6/30/2018 | 22 |
Jack | Rossy | 1/1/2018 | 12/31/2018 | 40 |
Mary | Rossy | 1/1/2018 | 12/31/2018 | 24 |
Anna | Sandra | 1/1/2018 | 12/31/2018 | 22 |
Eric | Allan | 1/1/2018 | 12/31/2018 | 9 |
Jimmy | Allan | 1/1/2018 | 12/31/2018 | 10 |
John | Smith | 4/1/2018 | 12/31/2019 | 14 |
Steve | Rossy | 8/1/2018 | 12/31/2018 | 5 |
Mark | Smith | 1/1/2018 | 12/31/2018 | 18 |
Bill | Allan | 7/1/2018 | 12/31/2018 | 36 |
I am able to display the data in the form of pie-chart but I am unable to reflect the change of managers in it. The employees are being dispayed in both of their managers listing in the pie chart(the previous and present manager under which they been associated).
Could you please help me with the steps to implement it or any kind of help will be appreciated?
Thanks and Regards,
Bhavesh
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
63 |
User | Count |
---|---|
135 | |
126 | |
110 | |
70 | |
61 |