Description
Count distinct cells, distinct cells with at least one supported row, and distinct source IDs on supported rows.
Survey display order, self-description, missingness, and record support are distinct research properties. Literal tokens and counts can preserve those distinctions without inferring a person's identity, preferences, or the meaning of an unprovided response.
Count distinct cells, distinct cells with at least one supported row, and distinct source IDs on supported rows.
When to use this tool
Use Representation Support Cell Count when you need a transparent survey-record, display-order, or time-use calculation.
How to use the tool and how it works
- Enter cellKeys, sourceIds, supported. Keep parallel arrays aligned. Use the units and conventions below.
- Run the tool. Correct any format, range, or cross-field input error before interpreting the output.
- Read cells, supportedCells, distinctSupportingSources. Use the output convention below.
Require equally long cellKeys, sourceIds, and supported arrays. Count distinct cells, distinct cells with at least one supported row, and distinct source IDs on supported rows.1
| Input field | Meaning and units | Accepted input |
|---|---|---|
| cellKeys | Cell Keys | Required. Array of text; maximum UTF-16 length 8192; maximum items 256. |
| sourceIds | Source Ids | Required. Array of text; maximum UTF-16 length 8192; maximum items 256. |
| supported | Caller-supplied support flag, not an independently verified evidence assessment. | Required. Array of boolean; maximum items 256. |
| Output field | Interpretation | Returned shape |
|---|---|---|
| cells | Cells | Required. Safe integer. |
| supportedCells | Supported Cells | Required. Safe integer. |
| distinctSupportingSources | Distinct Supporting Sources | Required. Safe integer. |
{
"input": {
"cellKeys": [
"a",
"a",
"b"
],
"sourceIds": [
"s1",
"s2",
"s1"
],
"supported": [
true,
false,
true
]
},
"output": {
"cells": 2,
"supportedCells": 2,
"distinctSupportingSources": 1
}
}Limitations and assumptions
- Any supported row covers a cell; duplicate rows do not add distinct cells or sources. Support flags are metadata, not independently verified evidence or a representativeness assessment.
- Inputs must satisfy both the field types and the cross-field conditions above. Invalid input causes an error; a successful false flag or documented placeholder is a different result.
Alternative or Complementary methods
Use the study's consent, vocabulary, missingness, and disclosure methodology for interpretation. Retain self-described information and assess sampling and privacy separately from local record arithmetic.
References
Similar or alternative tools
- Representation Count Suppression Flag
Return suppressed for count below the minimum, or at or below it when suppressEquality is true.
- Survey Self Description Missingness
For each response, optionally apply JavaScript trim before comparing it exactly with the supplied missingTokens.