Multiple merge on the same panel

Hi all, I’m kinda new using Grafana and I would like to know if there is any option to make two merges in the same panel about different queries that are inside of it. Also, does anyone know any site which says how to use variables when you are using pnp4nagios as datasource? I couldn’t find anything about it.

Sorry if my english is bad, not my best languague.
Thanks for all.

Hi all, I’m kinda new using Grafana and I would like to know if there is
any option to make two merges in the same panel about different queries
that are inside of it.

Please can you explain what you mean by “two merges”. Maybe give us an
example to show what you would like to achieve?

Also, does anyone know any site which says how to use variables when you are
using pnp4nagios as datasource? I couldn’t find anything about it.

I don’t understand “using pnp4nagios as a data source”.

pnp4nagios is not a data store - it’s a method of representing data from a
data store, which is also what Grafana is.

Data sources | Grafana Labs tells you which back-end
data stores are supported by Grafana. If your implementation of pnp4nagios is
taking data from one of those, then Grafana can too.

Antony.

Yes sorry for the confusion I’ll try to explain as good as I can.

Please can you explain what you mean by “two merges”. Maybe give us an
example to show what you would like to achieve?

I would like to have 2 “squares” where each one of them represents multiple windows services monitorized, if I would want only one “square” I should just transform and merge all, but can I only merge for example 4 of the 6 queries that are inside the panel and then merge the other 2 in another square?

Here is an image to try to clear the “square” thing: Imgur: The magic of the Internet

I don’t understand “using pnp4nagios as a data source”.

True, my bad about this one too, I have monitorized some hosts and services with Nagios and then using PNP included to Grafana, the thing is that I don’t know how to make variable queries because most of the other examples are from PostgresSQL/InfluxDB etc. which I dont have. I tried to know/understand from where I’m getting all the data but it seems like the MariaDB that I have installed doesnt collect any data, is there any option to know that?

Yes sorry for the confusion I’ll try to explain as good as I can.

Please can you explain what you mean by “two merges”. Maybe give us an
example to show what you would like to achieve?

I would like to have 2 “squares” where each one of them represents multiple
windows services monitorized, if I would want only one “square” I should
just transform and merge all, but can I only merge for example 4 of the 6
queries that are inside the panel and then merge the other 2 in another
square?

Here is an image to try to clear the “square” thing:
Imgur: The magic of the Internet

No, I’m sorry but I still don’t understand what you want to do, and that link
shows me a dark grey background in my browser and nothing else.

I have monitorized some hosts and services with Nagios and then using PNP
included to Grafana, the thing is that I don’t know how to make variable
queries because most of the other examples are from PostgresSQL/InfluxDB etc.
which I dont have. I tried to know/understand from where I’m getting all the
data but it seems like the MariaDB that I have installed doesnt collect any
data, is there any option to know that?

If you have installed Nagios and PNP4Nagios in “the standard way” then the
data being shown in PNP4Nagios is being stored in an RRD database, which:

a) I do not believe can be queried by Grafana

b) strikes me as a bad choice for a data store to use with Grafana queries
(even if it were possible), because RRD inherently deletes / amalgamates older
data to conserve storage space. If you store one data point per minute in
RRD, then the data from a year ago probably only exists as one point per hour
or one point per day.

It sounds to me that you need to select a data store which is supported by
Grafana, and can be written to by Nagios (since that’s where your data is
ultimately coming from), then you will have data coming in from your service
checks, being displayed in Nagios, also being fed into RRD for PNP4Nagios, and
going to a data store which Grafana can use.

I hope that helps,

Antony.

Hi Antony, I finally solved the second problem but it maintains the first one. The thing is that when you create a new panel you can place some queries just like the follow image.

Following this example, if I had 7 queries but I want to divide them in 2 big groups (imagine that I have two servers, on the first one there are 3 services monitorized and at the other one 4), but I’m trying to show only with 1 green/red rectangle (per server, two in total) that depends the color change if one of those services are up or not, what would be the procedure to make it?

Sorry for all the inconveniences and thanks for replying.