Introduction
This article describes how to go from a crosstab with averages on the bottom to a table that includes the averages in the column labels:
Requirements
A crosstab with a statistic on the bottom that you want to include in each column header. Neither of the Blue or Brown questions can be grids.
Method
1. Select your table.
2. Go to Automate > Custom Rule.
3. Paste the below into the dialog:
form.setHeading("Add table statistic to column labels");
form.setSummary("Add table statistic to column labels");
includeWeb('Table JavaScript Utility Functions');
// Set parameters and text
var statistic_to_add = "Average";
var decimals = 2;
var text_before = "Average =";
// Get labels and values
var vals = below_table.get(statistic_to_add);
var col_labs = table.columnLabels;
var new_labs = [];
// Loop through each column
for (var col = 0; col < table.numberColumns; col++) {
// Create string with old column label and value of specified statistic
var val = parseFloat(vals[0][col]);
var old_lab = col_labs[col];
var new_lab = old_lab + "\n (" + text_before + " " + val.toFixed(decimals) + ")"
new_labs[col] = new_lab;
}
// Set new column labels
table.columnLabels = new_labs;
- In this code, we first define the statistic (Average, in the example provided in the table above) to use and the format of the text to be appended to each column label.
- Next, we loop through each column and extract the relevant value.
- Each iteration of the loop then appends "(Average = value)" to the existing column label after a line break.
4. OPTIONAL: Change statistic_to_add to use a different statistic other than Average.
5. OPTIONAL: Change decimals to include more or less decimal places.
6. OPTIONAL: Change text_before to adjust the text to append to the row label.
7. OPTIONAL: Right-click your table > Statistics - Below and untick Average.
8. Press the Play button > Close > OK > OK.