When you want to create a column that averages multiple numeric columns, you can use the summarize_row function to calculate the average values across multiple columns.
Select “Create Calculation” > “Standard” from the column header menu.
Specify the calculation formula as follows:
Examples: Specifying columns directly:
summarize_row(across(c(column_name1, column_name2)), mean, na.rm = TRUE)
Specifying a range of consecutive columns:
summarize_row(across(c(start_column_name:end_column_name)), mean, na.rm = TRUE)
