Conditionally coloring column(s)
In SuperTables you can conditionally color columns to better visualize your data.
Step 1: Open Configuration
This can be done by clicking your the container that has super tables on your dashboard.
Step 2: Navigate to the Data tab
Step 3: Select your column
Select your column and scroll down to the coditional coloring section
Step 4: Setting up your first conditional coloring
Select color cell background from the radio options.
Select a target column, select the same column as the one you have navigated to.
Select a below bounds color by clicking on the color swatch
Select a above bounds color by clicking on the color swatch
Setup an inbounds color.
Setup a lower bound.
if your measure spans from -100 to 100 and you want any value below 0 to be colored according to your below bounds color then choose 0 as your lower bound.
Setup an upper bound.
if your measure spans from -100 to 100 and you want any value above 50 to be colored according to your below bounds color then choose 50 as your upper bound.
Click Apply and Close
Now your measure should be color with your chosen colors.
The section below explains all the additional coloring options available.
Conditional Coloring Options
Color cell background
This options applying your coloring settings to the cell background
Color cell text
This options applying your coloring settings to the cell background
Color entire row
By default the conditional coloring is only applied to the column but with option you can apply it to the whole row instead.
Target Column
The column you use to color the column. The target column can be any other column. You can use one column to color another.
Color bounds
Lower Bound: The minimum value, anything value in column that is below this value will be colored with below bounds color.
Upper Bound: The maximum value, anything value in column that is above this value will be colored with below bounds color.
Below-Bounds Color: Color used to color values lower than or equal to lower bound.
Above-Bounds Color: Color used to color values higher than or equal to Upper bound.
In-bounds Color: Color used to color values between lower and upper bound.
Using a gradient
By default conditional coloring uses discrete values for upper, in and lower bounds but turning this option on will convert discrete coloring to gradient (continuous) resulting from lower bound to upper bound.
Custom font color
You can also assign a custom color to your font. The default color is black
Barchart
Instead of just coloring the cell you can also create a bar chart within the cell.
Min-Value: is the value where your barchart length is 0.
Max-Value: is the value where your barchart length is 100.
Last updated