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 IDH1 expression TCGA GBM. Start by choosing the TCGA GBM cohort. Next, enter IDH1 and choose 'gene expression' and 'somatic mutation'. Your screen should look as below:
Next we will type into the highlighting search bar:
This will highlight all the samples that have data for both columns (red box down side of the visual spreadsheet).
Next click on the filter button (upside down pyramid next to the question icon and choose 'Filter'). This will filter down the samples to just the ones you selected. Your screen should now look like below.
Click here to see all our search options.