List View

When to Use List Views

List views can be used to visualize categorical data.

When creating a list view:

• 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

Using List Views to Visualize Hierarchically Organized Data

List views, unlike row charts, can be used to visualize categorical data with values that are organized in a hierarchical fashion.

Using List Views to Visualize Data from Two Different Fields

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.

Using List Views in the Cohort Browser

Visualizing Data from a Single Field

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. In the current cohort selection of 80 participants, 13 records contain the value "Delivery episode", which represents 16.25% of the current cohort size.

Visualizing Data from Two Fields

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.

Visualizing Complex Categorical Data

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 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 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

Locating Values in a List View

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:

List Views in Cohort Compare

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:

In each column, count and "freq." figures refer to the occurrence of values in the individual cohort, not across both cohorts.

Preparing Data for Visualization in List Views

When ingesting data using Data Model Loader, the following data types can be visualized in list views:

• 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