List View
Learn to build and use list views in the Cohort Browser.
Last updated
Was this helpful?
Learn to build and use list views in the Cohort Browser.
Last updated
Was this helpful?
List views can be used to visualize categorical data.
When creating a list view, note that:
The data must be from a field that contains either categorical or categorical multi-select data
This field must contain no more than 20 distinct category values
The values can be organized in a hierarchy
Supported Data Types
Note that list views, unlike , can be used to visualize categorical data with values that are organized in a hierarchical fashion.
List views can be used to visualize categorical data from two different fields. The same restrictions apply to the fields whose values are displayed, as when creating a simple list view.
In a list view in the Cohort Browser showing data from one field, each row displays a value, along with the number of records in the current cohort - the "count" - that contain this value. Also shown is a figure labeled "freq." - this is the percentage of all cohort records, that contain the value.
Below is a sample list view showing the distribution of values in a field Episode type. Note that In the current cohort selection of 80 participants, 13 records contain the value "Delivery episode", which represents 16.25% of the current cohort size.
To visualize data from two fields, select a categorical field, then select "List View" as your visualization type. In the field list, select a second categorical field as a secondary field.
Below is the default view of a sample list view visualizing data from two fields: Critical care record origin and Critical care record format:
Critical care record origin is the primary field, Critical care record format is the secondary field.
Here, the user has clicked the ">" icon next to "Originating from Scotland" to display additional rows with detail on records that contain that value in the field Critical care record origin:
Each of these additional rows shows the number of records that contain a particular value for Critical care record format, along with the value "Originating from Scotland" for Critical care record origin.
In these additional rows, "count" and "freq." figures refer to records having a particular combination of values, in the fields in question.
Below is an example of a list view used to visualize data in a categorical hierarchical field Home State/Province:
By default, only values in the category at the top level of the hierarchy are displayed.
Here, the user has clicked ">" next to one of these values, revealing additional rows that show how many records have the value "Canada" for the top-level category, in combination with different values in the category at the next level down:
In these additional rows, "count" and "freq." figures refer to records having a particular combination of values, in the fields in question. In the list view above, for example, a single record, representing 10% of the cohort, has both the value "Canada" for the top-level category, and "British Columbia" for the second-level category.
The following example shows how "count" and "freq." are calculated, for list views based on fields containing categorical data organized into multiple levels of hierarchy:
For the bottommost row, "count" and "freq" refer to records having all of the following values:
"Yes" for the category at the top of the hierarchy
"9" for the category at the second level of the hierarchy
"8" for the category at the third level of the hierarchy
"7" for the category at the fourth level of the hierarchy
"3" for the category at the bottom level of the hierarchy
In cases where the field has categories at multiple levels and this make it difficult to find a particular value, use the search box at the bottom of the list view, to hone in on a row or rows containing that value:
In Cohort Compare mode, a list view can be used to compare the distribution of values in a field that's common to both cohorts. In this scenario, the list includes a color-coded column for each cohort, as well as color-coded "count" figures for each, as in this example:
Note that in each column, count and "freq." figures refer to the occurrence of values in the individual cohort, not across both cohorts.
String Categorical
String Categorical Hierarchical
String Categorical Multi-Select
String Categorical Multi-Select Hierarchical
String Categorical Sparse
String Categorical Sparse Hierarchical
Integer Categorical
Integer Categorical Hierarchical
Integer Categorical Multi-Select
Integer Categorical Multi-Select Hierarchical
Categorical (<=20 distinct category values)
Categorical Multiple (<=20 distinct category values)
Categorical Hierarchical (<=20 distinct category values)
Categorical Hierarchical Multiple (<=20 distinct category values)
In some cases, not all records will have a value for the field in question. In this case, summing the "count" figures displayed will yield a figure smaller than the total cohort size, and summing the "freq." figures will not yield "100%." See for more information.
When , note that the following data types can be visualized in list views:
