Compare two columns in a table and alert/colorize if they're different

Grafana Table Panel
1

Is there a way to alert/color code based on differences in two columns of a table?

I’m comparing an installed version of a package to what version of the package SHOULD be installed, all data being pulled from a MySQL table.

so basically if column local is v2 and column ‘should be installed’ is v3, just make one of the columns red, and if they’re the same, then keep them green.

Our package versions are alpha-numeric, something like 20170814-73-6.6.0-9c61259-master.

Thanks a bunch in advance!

2

No this is currently not possible

3

Hey Torkel,

Problem- " Compare two columns in a table and alert/colorize if they’re different"

Is this problem solved in the latest versions of the release? Please let me know if not then, how can I handle this type of problem. Please suggest me alternative solutions too.

Thanks and regards,
Sachin mishra

2 Likes
4

hello, i have the same need.

Is it possible to do now?

5

Do you want to send a grafana alert or color some grafana visual

6

I want to send grafana alert.

using prometheus data source

  • i have 2 queries that retrieve metrics in a table for each query from nodes

  • if there is a row missing or different value from the other table - should be an alert