Discrete plugin Grafana with Buienradar binding

brizzik · March 24, 2020, 9:35pm

Hey guys,

I installed the buienradar binding a couple of days ago and in the binding page there is a really nice grafana chart to display.

I tried to copy this on grafana but i cant make it work like the one in the binding page.
Did someone allready make this or is there something with knowledge about the discrete plugin for grafana.

This is my result:

Well, i think we all agree that does not look like the one on the binding page…

Hope someone can help me in the right direction.

Thanks in advance

Charley · March 25, 2020, 8:15am

Did you add the mapping, to get the proper colors?

The mappings are as follows:

0 – 0.01: None (rgba(204, 204, 204, 0))
0.01 – 1: Very light (#badff4)
1 – 5: Light (#6ed0e0)
5 – 20: Medium (#1f78c1)
20 – 50: Heavy (#ef843c)
50 – 80: Very heavy (#e24d42)
80 – 100: Extremely heavy (#890f02)

brizzik · March 25, 2020, 11:00am

Hello @Charley

I tried it like this:

I dont really understand wich mappings have to be in what place.

Charley · March 25, 2020, 11:07am

i will add the binding asap. and see if I get it working

brizzik · March 25, 2020, 11:09am

Thats amazing.
Thanks in advance!

Charley · March 25, 2020, 12:00pm

I have installed it. Now needs to wait to retrieve enough data.
Here in Noord-Brabant the first rain is forecasted on Sunday.
As soon as i have some useable data I’ll get back to you.

brizzik · March 25, 2020, 12:30pm

Dankjewel man! Ik wacht het even af

Charley · March 30, 2020, 8:14am

I know how is has to be done.
The green bar is there because there is no value.

So I have changed to Color mapping to

colormapping

Based on the following range mapping

rangemapping

Then i have set the GROUP BY in grafana database to time(5m)

This way it will work, with the little data that can in the last few days.

based on this data

+---------------------+-------+
| Time                | Value |
+---------------------+-------+
| 2020-03-29 10:43:18 |  0.29 |
| 2020-03-29 10:53:18 |  0.49 |
| 2020-03-29 11:08:19 |  0.29 |
| 2020-03-29 11:13:19 |     0 |
+---------------------+-------+
4 rows in set (0.00 sec)```

Good luck!

brizzik · March 30, 2020, 2:24pm

Its better to use the text from the range mappings in the color mappings.

Like this:

Instead of this

Now it looks like this: