Retrieve members of a cohort
The DCCOHORTMEMBERS
formula returns the members of each cohort provided. Here a cohort is a general term for a group of entities, like the CDC’s list of the United States’ 500 largest cities.
Formula
=DCCOHORTMEMBERS(dcids)
Required arguments
dcids
- A single node or range of cells representing nodes, identified by their DCIDs, whose members are sought.
Returns
The DCIDs of the cohort members. For a single DCID, the result is a column of members of the cohort represented by that DCID. For a row of DCIDs, the result is a matrix with each column the members of the cohort whose DCID serves as the column’s index. For a column of DCIDs, the result is a matrix with each row the members of the cohort whose DCID serves as the row’s index.
Example: Retrieve the list of cities that are members of the CDC 500 cohort
Note: Be sure to follow the instructions for for enabling the Sheets add-on before trying this example.
To retrieve the members of the CDC 500 cities cohort:
- Place your cursor in any cell, say A1, and enter
CDC500_City
. -
In cell B1, enter
=DCCOHORTMEMBERS(A1)
.The list of member DCIDs populates column B.
- (Optional) To get the names of the members, in cell C1, enter
DCGETNAME(B1:B500)
.
Page last updated: November 27, 2024 • Send feedback about this page