Lens color by value issue when using formula metrics

[cgchamb]

Elasticsearch: 8.19.5, Kibana: 8.19.5.

I’m using the Sample Flight data set and I’ve created a Lens Table with “Rows: Top 5 values of Carrier” and Metric “Count of DestAirportID”. I set the metric to color by value (Cell) with value >= 3000 as one color and anything less as another color. I can add more metrics with separate color options and the table works correctly, but as soon as I add a metric that uses a formula, it changes the coloring of other metrics. Example, I added a simple metric with formula “1+1” and this is the result:

[cgchamb]

Elasticsearch: 8.19.5, Kibana: 8.19.5.

I’m using the Sample Flight data set and I’ve created a Lens Table with “Rows: Top 5 values of Carrier” and Metric “Count of DestAirportID”. I set the metric to color by value (Cell) with value >= 3000 as one color and anything less as another color. I can add more metrics with separate color options and the table works correctly, but as soon as I add a metric that uses a formula, it changes the coloring of other metrics. Example, I added a simple metric with formula “1+1” and this is the result:

I did confirm that this was not a problem in 8.18.1 (we recently upgraded to 8.19.5)

[Tortoise]

Hello @cgchamb

Welcome to the Community!!

Tried on latest version of Elastic 9.2.3 and do not see this issue :

Yes in 8.19.5 it seems to be a bug :

But in the same session if you delete the formula and add again it works in 8.19.5 :

So ideally it is a bug but if you try to remove & add again in same session it works as above..can try as a temporary solution.

Thanks!!

[cgchamb]

@Tortoise Thanks for your reply. The workaround you provided is not working for me. However, I did find a different workaround. I moved the formula metric above the “Count of DestAirportID” metric and now the coloring works. I added more metrics, and as long as I keep the formula metrics above non-formula, all the coloring works.