This function scans a standard query output for groups with high levels of Work Week Span. Returns a plot by default, with an option to return a table with a all of groups (across multiple HR attributes) ranked by work week span.

workloads_rank(
  data,
  hrvar = extract_hr(data),
  mingroup = 5,
  mode = "simple",
  plot_mode = 1,
  return = "table"
)

Arguments

data

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

hrvar

String containing the name of the HR Variable by which to split metrics. Defaults to "Organization". To run the analysis on the total instead of splitting by an HR attribute, supply NULL (without quotes).

mingroup

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

mode

String to specify calculation mode. Must be either:

  • "simple"

  • "combine"

plot_mode

Numeric vector to determine which plot mode to return. Must be either 1 or 2, and is only used when return = "plot".

  • 1: Top and bottom five groups across the data population are highlighted

  • 2: Top and bottom groups per organizational attribute are highlighted

return

String specifying what to return. This must be one of the following strings:

  • "plot" (default)

  • "table"

See Value for more information.

Value

A different output is returned depending on the value passed to the return argument:

  • "plot": 'ggplot' object. A bubble plot where the x-axis represents the metric, the y-axis represents the HR attributes, and the size of the bubbles represent the size of the organizations. Note that there is no plot output if mode is set to "combine".

  • "table": data frame. A summary table for the metric.

Details

Uses the metric Workweek_span. See create_rank() for applying the same analysis to a different metric.

Examples

# Return rank table
workloads_rank(
  data = sq_data,
  return = "table"
)
#> # A tibble: 18 × 4
#>    hrvar            group              Workweek_span     n
#>    <chr>            <chr>                      <dbl> <int>
#>  1 FunctionType     Sales                       52.4    66
#>  2 FunctionType     Marketing                   52.1   125
#>  3 LevelDesignation Manager                     44.1   200
#>  4 Organization     Human Resources             44.0    71
#>  5 LevelDesignation Senior IC                   43.9    67
#>  6 Organization     Finance                     43.6   292
#>  7 LevelDesignation Director                    42.8    43
#>  8 LevelDesignation Junior IC                   42.5    58
#>  9 Organization     IT                          41.8   130
#> 10 Organization     Customer Service            41.6    61
#> 11 LevelDesignation Support                     41.3   257
#> 12 FunctionType     Engineering                 41.1    49
#> 13 Organization     Financial Planning          40.1    75
#> 14 FunctionType     Operations                  39.8   115
#> 15 FunctionType     R_and_D                     38.1    74
#> 16 FunctionType     IT                          37.4    22
#> 17 FunctionType     Finance                     37.4    74
#> 18 FunctionType     G_and_A                     37.2   104

# Return plot
workloads_rank(
  data = sq_data,
  return = "plot"
)