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

Supported Data Types
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. Note that 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

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 Chart Totals and Missing Data for more information.

Preparing Data for Visualization in Row Charts

When ingesting data using Data Model Loader, note that the following data types can be visualized in row charts, provided that 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.