Powerpoint templates can also contain a command code that builds up a respondent level answer table.
This works as follows:
- First you built up a PowerPoint table on a slide of its own, styling etc permited but refrain from adding additional dynamic elements. This could look something like this:
- Next add a code like the following in the alt text property:
- This example has the following meaning (the main command parts are separated by a semi-colon):
- table:2 - This is a table command that should be applied on the second level run.
- "YearMonth,NPSScore,Feedback,Reason1,Reason2,Region" is a list of variables that should be present in the dataset, It is the values of these variables that are displayed in the table one respondent per row.
- "YearMonth:D:1false,NPSScore:D" is a sorting specification, in this case build up of two parts separated by a comma. The first part of the specification exists of four parts separated by a colon and says sort on "YearMonth" descending "D", show only rows that have the first value after sorting '1' and do not show value in the table 'false'
This is all there is to it, DataDynamic will when this command is executed, duplicate this slide and fill up the rows with the requested data. If there are less cases in the dataset then rows in the table the additional rows will be removed. If there are more cases an extra copy of the slide will be made, this continues until all cases have been added. Once completed the original slide will be removed. DataDynamic has a hardcoded limit of 2500 cases that it can add to prevent accidental creation of massive Powerpoint files. There is no indication in the report production process or in the output that this limit has been reached.
Please make sure, when you are working with open answer variables in the table, that there is room left at the bottom of the table as longer answers will grow the table vertically. A variable in the list can contain an additional max length specification by following the variable name with a colon and the length.
The specification of the table command is as follows, the command can exist of up to 4 main parts separated by a semi-colon:
|TABLE[:N]||This indicates the table command and optionally the runlevel on which it needs to be executed.|
|v1,v2,v3:200[,...]||A comma separated list of variable names as they exist in the dataset. A variable can be followed by a colon and a maximum length specification.|
v1 - is the variable name to sort on, this variable should be available in the variable list above.
A|D - optional sort order specification, either A(scending)|D(escending)
N - optional maximum number of unqiue values to show starting at the top after sorting, this can only be specified if sort has been specified.
true|false - Include this variable in the table output, if false this variable will be dropped from the output. (this means that the table does not require a column for it)
|filter||An additional filter can be specified, in this example you could restrict the answers to only those that have scored the NPS as a promotor.|