Analyze weekly External Collaboration hours distribution, and returns a 'fizzy' scatter plot by default. Additional options available to return a table with distribution elements.

external_fizz(data, hrvar = "Organization", mingroup = 5, return = "plot")

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.

return

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

  • "plot"

  • "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 jittered scatter plot for the metric.

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

Details

Uses the metric Collaboration_hours_external. See create_fizz() for applying the same analysis to a different metric.

Examples

# Return plot
external_fizz(sq_data, hrvar = "LevelDesignation", return = "plot")


# Return summary table
external_fizz(sq_data, hrvar = "Organization", return = "table")
#> # A tibble: 15 × 8
#>    group                 mean median    sd   min   max range     n
#>    <chr>                <dbl>  <dbl> <dbl> <dbl> <dbl> <dbl> <int>
#>  1 Biz Dev               2.16   2.04 0.561 1.01   3.82  2.81    75
#>  2 Customer Service      3.51   1.96 3.81  0.971 15.4  14.4     61
#>  3 Facilities            3.42   2.53 1.86  1.05   6.93  5.88    72
#>  4 Finance-Corporate     2.71   1.95 1.72  0.860  7.99  7.13    68
#>  5 Finance-East          5.88   5.83 3.90  0.807 14.4  13.6     70
#>  6 Finance-South         3.67   2.33 2.24  1.13   7.78  6.65    81
#>  7 Finance-West          4.87   3.21 3.32  1.23  12.9  11.7     73
#>  8 Financial Planning    3.65   2.46 3.31  1.25  13.1  11.9     75
#>  9 G&A Central           3.57   2.70 2.07  0.881  7.48  6.60    57
#> 10 G&A East              2.18   2.11 0.551 0.827  3.42  2.60    65
#> 11 G&A South             3.86   3.67 2.06  1.02   8.84  7.82    76
#> 12 Human Resources       4.26   3.94 1.94  1.24   8.44  7.21    71
#> 13 IT-Corporate          5.41   3.76 4.43  0.993 15.6  14.6     68
#> 14 IT-East               3.30   3.41 1.54  0.923  8.59  7.67    62
#> 15 Inventory Management  6.49   4.66 3.78  1.39  15.9  14.5     60