Difference between revisions of "Column: CATI contact duplicate record"
(jrfconvert import) |
Cg huyphong (talk | contribs) |
||
| Line 1: | Line 1: | ||
| − | [[Category: | + | [[Category:Resource data caches]] |
| | ||
| Line 38: | Line 38: | ||
The axis generated for this column will look like below: | The axis generated for this column will look like below: | ||
| − | Axis text: "CATI contact duplicate record"Math base: "CATIContactDuplicateRecord"Pct base: "CATIContactDuplicateRecord!=empty" | + | Axis text: "CATI contact duplicate record" |
| + | <br>Math base: "CATIContactDuplicateRecord" | ||
| + | <br>Pct base: "CATIContactDuplicateRecord!=empty" | ||
| − | Option 1: Name="False"; Value="!CATIContactDuplicateRecord"Option 2: Name="True"; Value="CATIContactDuplicateRecord" | + | Option 1: Name="False"; Value="!CATIContactDuplicateRecord" |
| + | <br>Option 2: Name="True"; Value="CATIContactDuplicateRecord" | ||
|- align="left" valign="top" | |- align="left" valign="top" | ||
| style="border: 1px solid #010101" width="228" bgcolor="#FFC20E" | | | style="border: 1px solid #010101" width="228" bgcolor="#FFC20E" | | ||
| Line 49: | Line 52: | ||
=(count() where (interviewer == 12345) && (CATIContactDuplicated== FALSE) && (id==567800)) | =(count() where (interviewer == 12345) && (CATIContactDuplicated== FALSE) && (id==567800)) | ||
| − | + | ||
| − | |||
<!-- imported from file: 7865.htm--> | <!-- imported from file: 7865.htm--> | ||
Latest revision as of 05:49, 26 April 2011
Column: CATI contact duplicate record
|
Column |
CATI contact duplicate record |
|
Source |
This column will be set to true for the first instance of the same CATI contact 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 a CATI contact record was called multiple times (more CATI contacts for the same answer sheet) then the CATI contact record information will be copied multiple times foranswer sheet contact log record. |
|
Automatically given column name |
CATIContactDuplicateRecord |
|
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: "CATI contact duplicate record"
Option 1: Name="False"; Value="!CATIContactDuplicateRecord"
|
|
Comment |
As a CATI contact log record can occur in more than one data row this column helps you “SELECT DISTINCT” CATI contact records in a resource cache, so for example the following expression will return the number of CATI contacts which a specific interviewer already did for a specific CATI questionnaire. =(count() where (interviewer == 12345) && (CATIContactDuplicated== FALSE) && (id==567800))
|
