Creates a list of everyone at a specified start date and a specified end date then aggregates up people who have moved between organizations between this to points of time and visualizes the move through a sankey chart.

Through this chart you can see:

  • The HR attribute/orgs that have the highest move out

  • The HR attribute/orgs that have the highest move in

  • The number of people that do not have that HR attribute or if they are no longer in the system

track_HR_change(
  data,
  start_date = min(data$Date),
  end_date = max(data$Date),
  hrvar = "Organization",
  mingroup = 5,
  return = "plot",
  NA_replacement = "Out of Company"
)

Arguments

data

A Person Query dataset in the form of a data frame.

start_date

A start date to compare changes. See end_date.

end_date

An end date to compare changes. See start_date.

hrvar

HR Variable by which to compare changes between, defaults to "Organization" but accepts any character vector, e.g. "LevelDesignation"

mingroup

Numeric value setting the privacy threshold / minimum group size. Defaults to 5.

return

Character vector specifying what to return, defaults to "plot". Valid inputs are "plot" and "table".

NA_replacement

Character replacement for NA defaults to "out of company"

Value

Returns a 'NetworkD3' object by default, where 'plot' is passed in return. When 'table' is passed, a summary table is returned as a data frame.

Author

Tannaz Sattari Tabrizi Tannaz.Sattari@microsoft.com

Examples


dv_data %>% track_HR_change()
Finance-West → Finance-West 
8 count
G&A East → G&A East 
7 count
Biz Dev → Biz Dev 
6 count
Finance-East → Finance-East 
6 count
Customer Service → Customer Service 
5 count
G&A South → G&A South 
4 count
IT-Corporate → IT-Corporate 
4 count
Inventory Management → Inventory Management 
4 count
Finance-South → Finance-South 
3 count
Human Resources → Human Resources 
3 count
Facilities → Facilities 
2 count
Finance-Corporate → Finance-Corporate 
2 count
G&A Central → G&A Central 
2 count
Facilities → Customer Service 
1 count
Finance-Corporate → Out of Company 
1 count
Financial Planning → Financial Planning 
1 count
G&A East → Out of Company 
1 count
IT-Corporate → Out of Company 
1 count
IT-East → IT-East 
1 count
Out of Company → G&A South 
1 count
Out of Company → Out of Company 
1 count
Finance-West
8 count
Finance-West
G&A East
8 count
G&A East
Biz Dev
6 count
Biz Dev
Finance-East
6 count
Finance-East
Customer Service
5 count
Customer Service
G&A South
4 count
G&A South
IT-Corporate
5 count
IT-Corporate
Inventory Management
4 count
Inventory Management
Finance-South
3 count
Finance-South
Human Resources
3 count
Human Resources
Facilities
3 count
Facilities
Finance-Corporate
3 count
Finance-Corporate
G&A Central
2 count
G&A Central
Financial Planning
1 count
Financial Planning
IT-East
1 count
IT-East
Out of Company
2 count
Out of Company
Finance-West 
8 count
Finance-West
G&A East 
7 count
G&A East
Biz Dev 
6 count
Biz Dev
Finance-East 
6 count
Finance-East
Customer Service 
6 count
Customer Service
G&A South 
5 count
G&A South
IT-Corporate 
4 count
IT-Corporate
Inventory Management 
4 count
Inventory Management
Finance-South 
3 count
Finance-South
Human Resources 
3 count
Human Resources
Facilities 
2 count
Facilities
Finance-Corporate 
2 count
Finance-Corporate
G&A Central 
2 count
G&A Central
Out of Company 
4 count
Out of Company
Financial Planning 
1 count
Financial Planning
IT-East 
1 count
IT-East