Invert SparkLine in SingleStat


#1

In a dashboard I have multiple singlestat panels pulling windows process or service statuses. The services use a value of 0 for running, while the processes use 0 for not present. So while everything is working properly a service will use 0 and a process will be 1. This causes the singlestat sparklines for be inverse to each other and can be confusing at a glance.

I would like to be able to invert the sparkline for select panels so they all respectively show drops when failed and highs when running.


#2

You need to this in the query , most TSDB can perform basic math like inversions


#3

Thanks for the suggestion, although this data is being imported from zabbix mariadb plugin, not a time series like influx. Is this still valid?