Row Chart

Learn to build and use row charts in the Cohort Browser.

The Cohort Browser is accessible to all users of the UK Biobank Research Analysis Platform and the Our Future Health Trusted Research Environment.

For DNAnexus Platform users, an Apollo license is required to access the Cohort Browser. Contact DNAnexus Sales for more information.

When to Use Row Charts

Row charts can be used to visualize categorical data.

When creating a row chart:

• 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 cannot be organized in a hierarchy

Supported Field Types

Supported Data Types	Limitations
Categorical	≤20 distinct category values
Categorical Multi-Select	≤20 distinct category values

See When to Use List Views for Categorical Data if you need to visualize hierarchical categorical data.

When to Use List Views for Categorical Data

Row charts can't be used to visualize data in categorical fields that have a hierarchical structure. For this type of data, use a list view.

Row charts aren't supported in Cohort Compare mode. In Cohort Compare mode, row charts are converted to list views.

Using Stacked Row Charts for Multivariate Visualizations

Simple row charts can't be used to visualize data from more than one field. To visualize categorical data from two fields, you can use a Stacked Row Chart.

Using Row Charts in the Cohort Browser

In a row chart, each row shows a single category value, along with the number of records - the "count" - in which that value appears in the selected field. Also shown is the percentage of total cohort records in which it appears - its "freq." or "frequency."

Below is a sample row chart showing the distribution of values in a field Salt added to food. In the current cohort selection of 100,000 participants, 27,979 records contain the value "Sometimes", which represents 27.98% of the current cohort size.

Row Chart in the Cohort Browser

When records are missing values for the displayed field, the sum of the "count" figures will be smaller than the total cohort size, and the sum of the "freq." figures will be less than 100%. See Chart Totals and Missing Data for more information on how missing data affects chart calculations.

Preparing Data for Visualization in Row Charts

When ingesting data using Data Model Loader, the following data types can be visualized in row charts, if category values are specified as such in the coding file used at ingestion:

• String Categorical

• String Categorical Sparse

• String Categorical Multi-select

• Integer Categorical

• Integer Categorical Multi-select

While sparse serial data can be visualized using row charts, non-encoded values are currently not supported. These values will not appear as rows.