Byos heatmap tables can be configured to display custom labels or colors for values that fall outside a defined numeric range. This is useful when data contains very low or very high values.
For example, if most values of interest lie between 1 and 100, any value below 1 can be flagged with a label such as "<1" , making it immediately clear to the reader that those measurements fell below the reportable threshold.
Step 1 – Open the Heatmap Settings Panel
- In the Byos report, navigate to the tab containing the heatmap table or create a table from scratch.
- Click the Edit menu and open the Current tab's settings.
- Locate the Heatmap settings section within the settings panel.
Step 2 – Configure the Color Range and Out-of-Range Options
Within the Heatmap settings panel, configure the fields as described below. The screenshot shows an example where the range is set from 1 to 100.
Configure each field as follows:
- Minimum value: Enter the lower bound of your desired range (e.g. 1.00). Assign a color for this end of the gradient (e.g. white, #FFFFFF).
- Maximum value: Enter the upper bound (e.g. 100.00). Assign a color for this end of the gradient (e.g. blue, #0000FF).
- Color range count: Sets the number of discrete color steps in the gradient. The default of 255 provides a smooth, continuous gradient.
- Show out of range values: Tick this checkbox to enable out-of-range display.
- Value out of range color: Choose the fill color that will be applied to out-of-range cells (e.g. white, #FFFFFF).
- Value out of range label: Enter the text that will replace the numeric value in out-of-range cells (e.g. <1).
Step 3 – Save and Review the Report
- Save the tab settings.
- The heatmap table will now display the custom label in any cell whose value falls outside the configured range. In the example below, cells with values below 1 are shown as "<1" in white.
Additional Notes
- Use data min / Use data max: Tick these checkboxes to automatically set the minimum or maximum to the lowest or highest value present in the dataset, rather than a fixed number.
- Use an absolute min/max: When checked, the color scale is anchored to the configured values across all samples, preventing the gradient from rescaling per row or column.
- Multiple out-of-range colors: Use the Add color button to define additional color stops within the range, creating a multi-color gradient.
- Standard heatmap: Tick this option to revert to a default scale, overriding the custom color settings.