The reportbyrows tag alters the output of certain types of Topline tiles.
3-axis questions
Data output generated by 3-axis questions is organized by default around columns. Consider the following:
setlist: BRANDS 1. Apple 2. Toshiba 3. IBM 4. Dell 5. Acer setlist: QUALITIES 1. Speed 2. Accuracy 3. Reliability 1. Rate each vendor on each dimension type: pulldown rowsfrom: BRANDS colsfrom: QUALITIES optsfrom: series[1..5]
Data output is organized by column, with all rows iterating through each column:
| Q1R1C1 | Q1R2C1 | Q1R3C1 | Q1R4C1 | Q1R5C1 | Q1R1C2 | Q1R2C2 | Q1R3C2 | Q1R4C2 | Q1R5C2 | Q1R1C3 | Q1R2C3 | Q1R3C3 | Q1R4C3 | Q1R5C3 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5 | 1 | 5 | 3 | 4 | 5 | 1 | 2 | 5 | 2 | 3 | 4 | 2 | 2 | 5 |
Likewise, Topline tiles are organized with the colsfrom list displaying as columns, and the rowsfrom list as rows:
Adding reportbyrows: y into the widget alters the table's data output. The above example's data with reportbyrows is instead organized by row:
| Q1R1C1 | Q1R1C2 | Q1R1C3 | Q1R2C1 | Q1R2C2 | Q1R2C3 | Q1R3C1 | Q1R3C2 | Q1R3C3 | Q1R4C1 | Q1R4C2 | Q1R4C3 | Q1R5C1 | Q1R5C2 | Q1R5C3 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5 | 5 | 3 | 1 | 1 | 4 | 5 | 2 | 2 | 3 | 5 | 2 | 4 | 2 | 5 |
The Topline tile is also transposed:
Rows are columns, and columns are rows.
Adding reportbyrows to a widget modifies the variable output order, as noted above. Data collected before the the tag is added is preserved, but modifications to data output for a survey which is already fielding may cause complications if analysis is already built around the default ordering. It is best practice to warn relevant parties in such cases where this tag is to be added to a survey which already has live data.
For blocks
Using reportbyrows in blocks can be helpful in organizing reports in some circumstances. For example, suppose a table measuring KPC performance repeats for a set of brands:
setlist: BRANDS 1. Microsoft 2. Lenovo 3. Apple 4. Dell block: <<END 21. Please indicate how well this statement describes the <b>%%TEXT%%</b> brand.<p> type: radio table report by rows: y headings: Does not describe at all, Describes completely optsfrom: series [1..10] rows: randomize: y 1. Is competitively priced 2. Makes high quality products 3. Offers products with the features I want 4. Makes products that provide good value for the money 5. Is a brand I trust 6. Makes products that are easy to use END list: BRANDS
Because the brands are the iterated by the block, by default they would otherwise show as columns in the resulting grid tile. Using report by rows will flip the matrix to a more useful output, where brands show as rows:
Comments
0 comments
Please sign in to leave a comment.