I am using a Statistics table for the visualization of some data. Is there a way to colorize cells based on partial text values?
Example... I want a different cell color based on the first 3 letters of the values . I would want one cell color for all cells that start with BAX, a different color for cells that start with CAR , etc.
BAX11ROW3
BAX12ROW5
CAR01ROW4
CAR05ROW3
DOR01ROW6
You can do this with CSS - essentially you need to have a multivalue field with the colour you want in the second value - this can be the result of some calculation e.g. based on the first three characters of the field - then you can follow this link to see how it is done in similar circumstances