Version Notice: This article covers features in our r9/IS Pro platform. If you're looking for information on this topic related to r8, see rowpunchsummary.
The rowpunchsummary tag creates a summary variable for tables.
Similar to collectionpunchsummary, rowpunchsummary is considered a summary variable that "rolls up" the data.
1. How familiar are you with the following?
rowpunchsummary: QFAMILIAR. Familiar Q1 {if anyChecked($Q1R[id],3)}
rowpunchsummary: QUNFAMILIAR. Unfamiliar Q1 {if anyChecked($Q1R[id],1)}
type: radiotable
1. Never heard of
2. Heard of, not that familiar
3. Familiar
rows:
1. Advance Auto Parts
2. AutoZone
3. Napa Auto Parts
4. Pep Boys
5. O’Reilly Auto Parts
Details
- Apply
rowpunchsummaryto a table with rows and options. This tag is not applicable to vscale tables. - The tag's input includes the label (ID) and description of the summary variable it creates, followed by a condition that defines the criteria for punching the summary variable.
- Inclusion and exclusion filters can be added immediately after the label and description.
- Multiple
rowpunchsummarytags can be included on a single table.
Note: Row punch summary variable labels do not include the leading 'Q' by default. If a leading 'Q' is desired, be sure to include it in the rowpunchsummary tag as shown above.
Additional examples
Including or excluding rows
To include or exclude a row, insert the inclusion/exclusion filter after the reporting description, before the condition decorator. In the example below, only rows 1, 2, and 3 can be punched for QFAMILIAR.
1. How familiar are you with the following?
row punch summary: QFAMILIAR. Familiar Q1 [1..3] {if anyChecked($Q1R[id],3)}
type: radiotable
1. Never heard of
2. Heard of, not that familiar
3. Familiar
rows:
1. Advance Auto Parts
2. AutoZone
3. Napa Auto Parts
4. Pep Boys
5. O’Reilly Auto Parts
Adding quotas
You can include quotas: y as a decorator on the rowpunchsummary tag to create a quota based on the summary field. In the example below, the rowpunchsummary tag creates a summary variable called QFAMILIAR, and a quota called QFAMILIAR_QUOTA is added to the Quotas applet.
2. How familiar are you with the following?
rowpunchsummary: QFAMILIAR. Brand Familiarity {if anyChecked($Q2R[id],3)} {quotas: y}
type: radiotable
1. Never heard of
2. Heard of, not that familiar
3. Familiar
rows:
1. Adidas
2. Nike
3. Reebok
Referencing option data
If the table's rows include option data, it can be referenced in the rowpunchsummary condition. In the example below, the LOCAL option data is referenced in the condition within square brackets.
setlist: BRANDS
1. Fisher-Mills {{LOCAL: 1}}
2. Heaney {{LOCAL: 0}}
3. Armstrong {{LOCAL: 1}}
3. How satisfied are you with the following?
rowpunchsummary: QLOCAL_SAT. Local brands satisfied {if anyChecked($Q3R[id],3) and [LOCAL]==1}
type: radiotable
1. Unsatisfied
2. Neutral
3. Satisfied
rowsfrom: BRANDS
Using with 'unstackfor'
rowpunchsummary can also be combined with the unstackfor and unstackby tags to unpack stacked data and summarize helpful groupings such as Top 2 and Bottom 2 boxes.
set list: BRANDS 1. Brand 1 2. Brand 2 3. Brand 3
4. Imagine many more brands here set list: STATEMENTS 1. Statement 1 2. Statement 2 3. Statement 3 4. Statement 4 5. Statement 5 set list: AGREE 1. Strongly disagree 2. Disagree 3. Somewhat disagree 4. Somewhat agree 5. Agree 6. Strongly agree 2_BRANDS. Two brands type: coded multiple select
selectby: counts maxgroups: 2 opts from: BRANDS BRANDA. Brand A type: coded single select opts from: BRANDS {if anyChecked($Q2_BRANDS,[id])} BRANDB. Brand B type: coded single select opts from: BRANDS {if anyChecked($Q2_BRANDS,[id]) and noneChecked($QBRANDA,[id])} set list: SEL_BRANDS unstackfor: BRANDS 1001. $QBRANDA_text {desc: Brand A} 1002. $QBRANDB_text {desc: Brand B} start group: be1q loopfor: STATEMENTS BE1. ~text~ preface: Brand Equity type: radio table rows from: SEL_BRANDS opts from: AGREE rowpunchsummary: QBE1_TOP2 {if anyChecked($QBE1R[id],5,6)} rowpunchsummary: QBE1_BOTTOM2 {if anyChecked($QBE1R[id],1,2)} end group: be1q
Comments
0 comments
Please sign in to leave a comment.