Conditionally coloring column(s)
Last updated
Last updated
In SuperTables you can conditionally color columns to better visualize your data.
This can be done by clicking your the container that has super tables on your dashboard.
Select your column and scroll down to the coditional coloring section
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.
This options applying your coloring settings to the cell background
This options applying your coloring settings to the cell background
By default the conditional coloring is only applied to the column but with option you can apply it to the whole row instead.
The column you use to color the column. The target column can be any other column. You can use one column to color another.
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.
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.
You can also assign a custom color to your font. The default color is black
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.
