Removing Gray (null) Data From View
To remove all nulls across all columns: type "!=null"
To remove only nulls from a particular column: type "A:!=null" or "B:!=null", etc
Sometimes not all samples in a dataset have data, like in the case that a particular sample did not undergo gene expression analysis. In this case, we use gray to show that there is no data. This post will show how to remove these samples from view, allowing you to see a clearer picture.
As an example we will use ESR1 expression TCGA Breast Cancer. Start by choosing the TCGA Breast Cancer cohort, choosing 'gene expression (RNAseq)' and entering the gene 'ESR1'. Your screen should look as below:
Next we will type into the highlighting search bar:
This will highlight all the samples that have data (red box down side of the visual spreadsheet).
Next click on the filter button (next to 'Matching samples: 1218'). This will filter down the samples to just the ones you selected. Your screen should now look like below, with the red box showing the new filter.
Click here to see all our search options.