cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
jbhavesh077 Frequent Visitor
Frequent Visitor

Effective Date related mapping

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!

2 REPLIES 2
Moderator v-qiuyu-msft
Moderator

Re: Effective Date related mapping

Hi @jbhavesh077,

 

Please share some sample data and clarify corresponding desired results. 

 

Best Regards,
Qiuyun Yu 

Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
jbhavesh077 Frequent Visitor
Frequent Visitor

Re: Effective Date related mapping

Hi Qiuyun,

 

Please find below the sample data for which I am looking to plot a pie chart

EmployeeManagerStart dateEnd dateNo of Sales Unit
JohnRossy1/1/20183/31/201810
SteveSmith1/1/20187/31/201812
BillSandra1/1/20186/30/201822
JackRossy1/1/201812/31/201840
MaryRossy1/1/201812/31/201824
AnnaSandra1/1/201812/31/201822
EricAllan1/1/201812/31/20189
JimmyAllan1/1/201812/31/201810
JohnSmith4/1/201812/31/201914
SteveRossy8/1/201812/31/20185
MarkSmith1/1/201812/31/201818
BillAllan7/1/201812/31/201836

 

 

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