totals_bind: Row-bind an identical data frame for computing grouped totals

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

Row-bind an identical data frame for computing grouped totals

Description

Row-bind an identical data frame and impute a specific column with the target_value, which defaults as "Total". The purpose of this is to enable to creation of summary tables with a calculated "Total" row. See example below on usage.

Usage

totals_bind(data, target_col, target_value = "Total")

Arguments

data	data frame
target_col	Character value of the column in which to impute "Total". This is usually the intended grouping column.
target_value	Character value to impute in the new data frame to row-bind. Defaults to "Total".

Value

data frame with twice the number of rows of the input data frame, where half of those rows will have the target_col column imputed with the value from target_value.

See Also

Other Support: any_idate(), camel_clean(), check_inputs(), cut_hour(), extract_date_range(), extract_hr(), heat_colours(), is_date_format(), maxmin(), pairwise_count(), read_preamble(), rgb2hex(), totals_col(), tstamp(), us_to_space(), wrap()

Examples

pq_data %>%
  totals_bind(target_col = "LevelDesignation", target_value = "Total") %>%
  create_bar(hrvar = "LevelDesignation", metric = "Email_hours", return = "table")

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