Column: Answer sheet duplicate record

From Catglobe Wiki
Revision as of 05:42, 26 April 2011 by Cg huyphong (talk | contribs)
Jump to: navigation, search



Column: Answer sheet duplicate record

Column

Answer sheet duplicate record

Source

This column will be set to true for the first instance of the same answer sheet record that is added for a resource cache. Should any duplicates be added, then these will be set to false. The reason that duplicates may exist is when an answer sheet was called multiple times (more CATI contacts for the same answer sheet) then the answer sheet record information will be copied multiple times for each cati contact log record.

Automatically given column name

AnswerSheetDuplicateRecord

Column type

Boolean

Resource types that use it

Questionnaire

How axis set information is built

Since this is a boolean column, then the possible values that can exist in this column are only 0 and 1, which corresponds to "False" and "True". It is therefore easy to create the axis since we have a limited well defined number of outcomes.

The axis generated for this column will look like below:

Axis text: "Answer sheet duplicate record"Math base: "AnswerSheetDuplicateRecord"Pct base: "AnswerSheetDuplicateRecord!=empty"

Option 1: Name="False"; Value="!AnswerSheetDuplicateRecord"Option 2: Name="True"; Value="AnswerSheetDuplicateRecord"

Comment

As a answer sheet record can occur in more than one data row, this column helps you “SELECT DISTINCT” answer sheet records in a resource cache, so for example the following expression will return the number of times a specific respondent has taken part in the interviews of all questionnaires in QNR resource cache.

=(count() where (respondent == 83861) && (AnswerSheetDuplicated== FALSE) && (id!=empty))


Retrieved from "http://wiki.catglobe.com/index.php?title=Column:_Answer_sheet_duplicate_record&oldid=18325"