flag_extreme: Warn for extreme values by checking against a threshold

In vivainsights: Analyze and Visualize Data from 'Microsoft Viva Insights'

Warn for extreme values by checking against a threshold

Description

This is used as part of data validation to check if there are extreme values in the dataset.

Usage

flag_extreme(
  data,
  metric,
  person = TRUE,
  threshold,
  mode = "above",
  return = "message"
)

Arguments

data	A Standard Person Query dataset in the form of a data frame.
metric	A character string specifying the metric to test.
person	A logical value to specify whether to calculate person-averages. Defaults to TRUE (person-averages calculated).
threshold	Numeric value specifying the threshold for flagging.
mode	String determining mode to use for identifying extreme values. "above": checks whether value is great than the threshold (default) "equal": checks whether value is equal to the threshold "below": checks whether value is below the threshold
return	String specifying what to return. This must be one of the following strings: "text" "message" "table" See Value for more information.

Value

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

• "text": string. A diagnostic message.

• "message": message on console. A diagnostic message.

• "table": data frame. A person-level table with PersonId and the extreme values of the selected metric.

See Also

Other Data Validation: check_query(), extract_hr(), flag_ch_ratio(), flag_em_ratio(), flag_outlooktime(), hr_trend(), hrvar_count(), hrvar_count_all(), hrvar_trend(), identify_churn(), identify_holidayweeks(), identify_inactiveweeks(), identify_nkw(), identify_outlier(), identify_privacythreshold(), identify_shifts(), identify_tenure(), track_HR_change(), validation_report()

Examples

# The threshold values are intentionally set low to trigger messages.
flag_extreme(pq_data, "Email_hours", threshold = 15)

# Return a summary table
flag_extreme(pq_data, "Email_hours", threshold = 15, return = "table")

# Person-week level
flag_extreme(pq_data, "Email_hours", person = FALSE, threshold = 15)

# Check for values equal to threshold
flag_extreme(pq_data, "Email_hours", person = TRUE, mode = "equal", threshold = 0)

# Check for values below threshold
flag_extreme(pq_data, "Email_hours", person = TRUE, mode = "below", threshold = 5)

vivainsights documentation built on Aug. 8, 2025, 6:21 p.m.