Row Chart
Learn to build and use row charts in the Cohort Browser.
Last updated
Learn to build and use row charts in the Cohort Browser.
Last updated
Copyright 2024 DNAnexus
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.
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
See When to Use List Views for Categorical Data if you need to visualize hierarchical 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.
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.
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.
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.
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.
Supported Data Types
Categorical (<=20 distinct category values)
Categorical Multi-Select (<=20 distinct category values)