Adding a total row creates an additional observation in the count summary that presents the total counts (i.e. the n's that are summarized). The format of the total row will be formatted in the same way as the other count strings.

add_total_row(e, fmt = NULL, count_missings = TRUE, sort_value = NULL)

Arguments

e

A count_layer object

fmt

An f_str object used to format the total row. If none is provided, display is based on the layer formatting.

count_missings

Whether or not to ignore the named arguments passed in `set_count_missing()` when calculating counts total row. This is useful if you need to exclude/include the missing counts in your total row. Defaults to TRUE meaning total row will not ignore any values.

sort_value

The value that will appear in the ordering column for total rows. This must be a numeric value.

Details

Totals are calculated using all grouping variables, including treat_var and cols from the table level. If by variables are included, the grouping of the total and the application of denominators becomes ambiguous. You will be warned specifically if a percent is included in the format. To rectify this, use set_denoms_by(), and the grouping of add_total_row() will be updated accordingly.

Examples

# Load in Pipe library(magrittr) tplyr_table(mtcars, gear) %>% add_layer( group_count(cyl) %>% add_total_row(f_str("xxxx", n)) ) %>% build()
#> # A tibble: 4 x 6 #> row_label1 var1_3 var1_4 var1_5 ord_layer_index ord_layer_1 #> <chr> <chr> <chr> <chr> <int> <dbl> #> 1 4 " 1 ( 6.7%)" " 8 ( 66.7%… " 2 ( 40.0%… 1 1 #> 2 6 " 2 ( 13.3%)" " 4 ( 33.3%… " 1 ( 20.0%… 1 2 #> 3 8 "12 ( 80.0%)" " 0 ( 0.0%… " 2 ( 40.0%… 1 3 #> 4 Total " 15" " 12" " 5" 1 4