Add Treshold below some min value

Grafana InfluxDB
1

Hello,
I’m very new to Grafana and I have watched some basic YT videos for beginners. They were quite helpful to get started.
However I have come across to a problem that was already discussed before, but was not able to find a proper solution.
I’m using influxdb and there is some process that regularly writes data to database together with timestamp. I use this data and show on a Dahsboard on Timeseries panel
The analog value I’m recording is in the range between -100 to 100 and I want to add the following tresholds: >80 yellow, >90 red, but also <-80 yellow and <-90 red. It seems that Treshold options are only above certain treshold and not below. Of course I’m able to mimic what I want by changing base color, but I feel this is not the right way, it is a bit of a workaround.

image
image1526×502 107 KB

The query I use is:
SELECT “channel_01” FROM “tank_readings” order by time
Is there a way to add threshold and then in some config file or json define > or <?

2

I think the way you did it IS the right way so far as Thresholds visible on a time series chart are concerned. Are you satisfied with the way the graph looks?

For alerting, you can specify < and > in the formulas that trigger the alert.

3

If this is the only way I am satisfied, there is still little thing and that is a blue dashed line below -80, which I would prefer to be yellow, just to have symmetry between upper and lower part.
For alerting I need to learn how this is done. I’m not familiar with alerting option.
Basically I want to have a small vertical bar gauge that shows current value and it changes color when threshold value is reached (above), but I0m trying to figure out how to do that when it is below a certain value