Effective Date related mapping

[jbhavesh077]

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!

[v-qiuyu-msft]

Hi @jbhavesh077,

Please share some sample data and clarify corresponding desired results. 

Best Regards,
Qiuyun Yu 

[jbhavesh077]

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