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 base 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 Properties > GENERAL > Name.
3. Select Calculation > Custom Code.
4. Go to Properties > R CODE in the object inspector.
5. Add a line defining the table based on the name from step 2, e.g. brand_att = table_name
6. Now paste in the below code 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) * 100
Note: the above code is based on the table shown above and is referring 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 Properties > GENERAL > Name.
3. Select Calculation > Custom Code.
4. Go to Properties > R CODE in the object inspector.
5. Add a line defining the table based on the name from step 2, e.g. brand_att = table_name
6. Now paste in the below code 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) * 100
Note: instead of column names the above code referred to column index. E.g., [,4] refers to the fourth data column in our table "Like".