This article describes how to use a summary grid table...
..to calculate an index score using the data from the table (e.g., an index score based on the following formula: Top 2 Box / (Top 2 Box + Bottom 2 Box) x 100):
Requirements
A table with multiple rows and columns.
Method 1 - Using column names
1. Select your table.
2. Copy the table name from General > General > Name.
3. Click Calculation > Custom Code from the toolbar.
4. Click on the page to place the object.
5. In the R Code editor, add a line defining the table based on the name from step 2, e.g. brand_att = table_name
6. Now paste in the code below to set and calculate the index formula:
t2b = brand_att[,"Like"] + brand_att[,"Love"]
b2b = brand_att[,"Hate"] + brand_att[,"Dislike"]
numerator = t2b
denominator = t2b + b2b
index = (numerator / denominator) * 100Note: the above code is based on the table shown above and refers to column names "Like", "Love", "Hate", and "Dislike", which can be changed to match column names used in your table.
Method 2 - Using the column index
1. Select your table.
2. Copy the table name from General > General > Name.
3. Click Calculation > Custom Code from the toolbar.
4. Click on the page to place the object.
4. In the R Code editor, add a line defining the table based on the name from step 2, e.g. brand_att = table_name
6. Now paste in the code below to set and calculate the index formula:
t2b = brand_att[,4] + brand_att[,5]
b2b = brand_att[,1] + brand_att[,2]
numerator = t2b
denominator = t2b + b2b
index = (numerator / denominator) * 100Note: Instead of column names, the above code referred to column index. E.g., [,4] refers to the fourth data column in our table "Like".