Can I define color range in Object

[ChrisaT]

Hi, im having issues with visualisations and defining colour ranges. Although I can override the colour via the legend in the visualisation adding this into a Canvas ignores the colours I set. It reverts to the default green to red.

Can I define the colours within the object? E.g. add a colour value to each range defined and remove the colorSchema.

"metric": {
  "percentageMode": false,
  "useRanges": false,
  "colorSchema": "Green to Red",
  "metricColorMode": "Labels",
  "colorsRange": [
    {
      "from": 0,
      "to": 9
    },
    {
      "from": 9,
      "to": 16
    },
    {
      "from": 16,
      "to": 18
    },
    {
      "from": 18,
      "to": 21
    },
    {
      "from": 21,
      "to": 24

[rashmi (kulkarni)]

I see that you are looking for conditional coloring in Canvas. There are few threads which discuss this in detail.See if it helps:

Conditional colouring using kibana canvas expression editor

@Catherine_Liu I have basically the same problem not with the font color but with the background color I have just one condition instead of two my approach is quite like the fist you gave to ksunil. I do a select count(*) and if it is greater than 0 the backround should be green otherwise it should be red. The expression editor looks like below filters | essql query="SELECT * FROM uacuser WHERE logintime > NOW() - INTERVAL 1 MONTH AND disabled = 0" | math "size(userid)" | metric "Users logge…

and there is a GH issue as well

[Canvas] Add UI for conditional arguments on elements

Hope it helps
Thanks
Rashmi

cc @Catherine_Liu