Hi, I'm facing an issue while creating a data table. I wish to change the colour of the cells on the basis of their percentage value. Data shown below:
The issue is that the field is of type 'number' while I want to display percentage values. This is possible by editing the settings of field under 'Index Patterns' (as shown).
However, I am unable to do both the required things (i.e. change the colour + change to percentage) as the 'Format' can either be set as Percentage or Colour (and not both). Is there a way to solve this?