Broken thresholds (colors doesnt apply in the correct way)

[PatrickHoeveler]

What happened:
Colors from thresholds doesn't apply correctly. In a table on our dashboard we use the override functionality on our columns to apply: thresholds -> value mappings -> cell display mode: color background. The colors aren't applied correctly. As a datasource we use elasticsearch.
Our bug:

• When opening the dashboard the colors are not loaded correctly. After going into the edit mode of the table and just clicking on color of the threshold and reselect it again - its applied correctly for this specific column. But when saving the changes again and reloading the whole dashboard its broken again.

What you expected to happen:
Thresholds and color mapping apply the way it was specified.

How to reproduce it (as minimally and precisely as possible):
Create a dashboard with a table panel. Elasticsearch documents with some number values. Fetch elasticsearch data as "logs" into the table. Apply "threshholds -> value mapping -> cell display mode: color background" on the number column. Save and reload the page. Check the post in grafana community for a picture of our setup and the bug: https://community.grafana.com/t/broken-thresholds-colors-doesnt-apply-in-the-correct-way/34492

Anything else we need to know?:

Environment:

• Grafana version: 7.0.4 (also testetd on 7.1)
• Data source type & version: elasticsearch version 7.0
• OS Grafana is installed on: docker
• User OS & Browser: windows 10, firefox
• Grafana plugins: -
• Others: -

[peterholmberg]

Hello @PatrickHoeveler , I'm trying to recreate this issue on 7.1.3 but I am unable to. I've tried recreating your conditions using the CSV Metric values scenario in the testData datasource.

I wonder if it would be possible for you to upload parts of your query response?

[hugohaggmark]

@PatrickHoeveler from the picture I can see you're using transforms, could you please share which transforms you're using in this case?

[torkelo]

Can you include your panel json?

[hugohaggmark]

@PatrickHoeveler I agree with Torkel and can you also show us the Inspect -> JSON -> DataFrame structure

especially the fields part:

[lwlei]

I also met an issue about colors with elastic search datasource. I am using grafana(version:7.1.5) to draw a table panel of elasticsearch datasource. I have set Thresholds and chosed Cell display mode. However, the corresponding columns of the table panel are grey instead of the color I have set in thresholds, just as the fourth screenshot shown.

[grafanabot]

We've closed this issue since it needs more information and hasn't had any activity recently. We can re-open it after you you add more information. To avoid having your issue closed in the future, please read our CONTRIBUTING guidelines.

Happy graphing!

[YavorK]

Grafana 8.0.2

https://gist.github.com/YavorK/fdac1dd9b1df5680abf65fa2e31166ff example of thresholds not applying.
all data is at 200+
threshold is at 80 (absolute)

things show with the standard color (black on white) also in the dark there (white on black)

screenshot: https://prnt.sc/16q6rvn