I have a cube view representing a kind of gantt chart. If there is movement in a month the value is 1, otherwise the value of the cell is 0.
What is the best way to generate a UX output (view or dashboard) where the cells with a value have a green background with a green font. All other cells should format white with with font.
Currently you can set conditional formatting by row and column by referencing specific row or column names. Assuming the rows are variable and the columns fixed it is currently “inconvenient but possible” to apply conditional formatting to the whole grid by separately specifying the conditional format for each column.
Currently we already have conditional formatting enhancements logged for
applying conditional format to whole grid
applying conditional format based on an attribute of column or row element rather than specified name
Here’s the conditional formatting example from the planning template example in the UX demo application.
So "qty" will give me blue. What’s the code for grey? I’ve used "bg-black-100" based on another conversation I had with @aalex. Is there a better way to specify a grey?
Hi @R.B
The samples from the demo application are really just examples. I can’t give you a good explanation why “qty” means is defined as “light blue background” because I don’t think there is one. In the next release we are aiming to include a table in the help showing all the pre-defined table classes and what they look like.
In the meantime @tganz could help you with providing a list of the table classes and how to define a new class if the format you want isn’t already there.