Merge up status and instance_name panel

Grafana Prometheus
,
1

  • What Grafana version and what operating system are you using?

    Grafana v12.2.1 (563109b696)

  • What are you trying to achieve?
    I am trying to merge the results of 2 prometheus metrics, up and server_name into one panel per node.The panel should include both the server name and ip address. The panel should be green if the node is up and red if the node is down.

  • How are you trying to achieve it?
    I have tried joining by field, but there is no option to select the instance ip address, a value both queries have in common.

    image
    image468×371 19.2 KB

  • What happened?
    The server_name is in a different panel to the one holding the ip address and up status.

    image
    image1775×319 63.2 KB

  • What did you expect to happen?
    For there to be a single panel to represent the node, containing both the name, ip address and colour reflecting the up status as pictured in this photoshopped output below.

    image
    image880×318 23.3 KB

  • Can you copy/paste the configuration(s) that you are having problems with?
    Panel JSON:

{
  "id": 1,
  "type": "stat",
  "title": "New panel",
  "gridPos": {
    "x": 0,
    "y": 0,
    "h": 8,
    "w": 12
  },
  "fieldConfig": {
    "defaults": {
      "mappings": [],
      "thresholds": {
        "mode": "absolute",
        "steps": [
          {
            "color": "green",
            "value": null
          },
          {
            "color": "red",
            "value": 80
          }
        ]
      },
      "unit": "short"
    },
    "overrides": []
  },
  "transformations": [
    {
      "id": "joinByField",
      "options": {
        "byField": "Time",
        "mode": "outerTabular"
      }
    }
  ],
  "pluginVersion": "12.2.1",
  "targets": [
    {
      "datasource": {
        "type": "prometheus",
        "uid": "ff33tt81bqs5cc"
      },
      "editorMode": "builder",
      "expr": "up",
      "legendFormat": "{{instance}}",
      "range": true,
      "refId": "A"
    },
    {
      "datasource": {
        "type": "prometheus",
        "uid": "ff33tt81bqs5cc"
      },
      "editorMode": "builder",
      "expr": "server_name",
      "hide": false,
      "instant": false,
      "legendFormat": "{{instance_name}}",
      "range": true,
      "refId": "B"
    }
  ],
  "datasource": {
    "type": "prometheus",
    "uid": "ff33tt81bqs5cc"
  },
  "options": {
    "reduceOptions": {
      "values": false,
      "calcs": [
        "lastNotNull"
      ],
      "fields": ""
    },
    "orientation": "auto",
    "textMode": "name",
    "wideLayout": true,
    "colorMode": "background",
    "graphMode": "none",
    "justifyMode": "auto",
    "showPercentChange": false,
    "percentChangeColorMode": "standard"
  }
}
2

One possible way is using the new public preview SQL Expression

image
image946×595 35.7 KB

3

using the query below, I am able to see the desired data in 1 row.

SELECT concat(B.instance_name, ' (', B.instance, ')') as combined, A.__value__ FROM B,A

image
image713×111 4.37 KB

My panel seems to successfully read the __value__, but not combined as it does not show up properly in the panel.

image
image1920×796 34.6 KB

What must I change the display name to in order to correctly show the value of combined? Additionally, I need to hide the value (in this case 1)

Updated Panel JSON

{
  "id": 1,
  "type": "stat",
  "title": "New panel",
  "gridPos": {
    "x": 0,
    "y": 0,
    "h": 8,
    "w": 12
  },
  "fieldConfig": {
    "defaults": {
      "mappings": [
        {
          "options": {
            "{{__value__}}": {
              "index": 0
            }
          },
          "type": "value"
        }
      ],
      "thresholds": {
        "mode": "absolute",
        "steps": [
          {
            "color": "green",
            "value": null
          },
          {
            "color": "red",
            "value": 80
          }
        ]
      },
      "displayName": "{{combined}}",
      "unit": "short"
    },
    "overrides": []
  },
  "pluginVersion": "12.2.1",
  "targets": [
    {
      "datasource": {
        "type": "prometheus",
        "uid": "df3t6x2p9reo0e"
      },
      "editorMode": "builder",
      "expr": "up",
      "hide": true,
      "legendFormat": "__auto",
      "range": true,
      "refId": "A"
    },
    {
      "datasource": {
        "type": "prometheus",
        "uid": "df3t6x2p9reo0e"
      },
      "editorMode": "builder",
      "expr": "server_name",
      "hide": true,
      "instant": false,
      "legendFormat": "__auto",
      "range": true,
      "refId": "B"
    },
    {
      "datasource": {
        "name": "Expression",
        "type": "__expr__",
        "uid": "__expr__"
      },
      "expression": "SELECT concat(B.instance_name, ' (', B.instance, ')') as combined, A.__value__ FROM B,A\n\n-- SELECT * FROM",
      "hide": false,
      "refId": "D",
      "type": "sql"
    }
  ],
  "datasource": {
    "type": "prometheus",
    "uid": "df3t6x2p9reo0e"
  },
  "options": {
    "reduceOptions": {
      "values": false,
      "calcs": [
        "lastNotNull"
      ],
      "fields": ""
    },
    "orientation": "auto",
    "textMode": "auto",
    "wideLayout": true,
    "colorMode": "background",
    "graphMode": "none",
    "justifyMode": "center",
    "showPercentChange": false,
    "percentChangeColorMode": "standard",
    "text": {
      "valueSize": 30,
      "titleSize": 40
    }
  }
}
4

I have since managed to hide the value. I now just need the display name to show up correctly.

image
image1920×988 98.4 KB

Panel JSON

{
  "id": 1,
  "type": "stat",
  "title": "New panel",
  "gridPos": {
    "x": 0,
    "y": 0,
    "h": 8,
    "w": 12
  },
  "fieldConfig": {
    "defaults": {
      "mappings": [
        {
          "options": {
            "{{__value__}}": {
              "index": 0
            }
          },
          "type": "value"
        }
      ],
      "thresholds": {
        "mode": "absolute",
        "steps": [
          {
            "color": "green",
            "value": null
          },
          {
            "color": "red",
            "value": 80
          }
        ]
      },
      "displayName": "{{combined}}",
      "unit": "short"
    },
    "overrides": []
  },
  "pluginVersion": "12.2.1",
  "targets": [
    {
      "datasource": {
        "type": "prometheus",
        "uid": "df3t6x2p9reo0e"
      },
      "editorMode": "builder",
      "expr": "up",
      "hide": true,
      "legendFormat": "__auto",
      "range": true,
      "refId": "A"
    },
    {
      "datasource": {
        "type": "prometheus",
        "uid": "df3t6x2p9reo0e"
      },
      "editorMode": "builder",
      "expr": "server_name",
      "hide": true,
      "instant": false,
      "legendFormat": "__auto",
      "range": true,
      "refId": "B"
    },
    {
      "datasource": {
        "name": "Expression",
        "type": "__expr__",
        "uid": "__expr__"
      },
      "expression": "SELECT concat(B.instance_name, ' (', B.instance, ')') as combined, A.__value__ FROM B,A\n\n-- SELECT * FROM",
      "hide": false,
      "refId": "D",
      "type": "sql"
    }
  ],
  "datasource": {
    "type": "prometheus",
    "uid": "df3t6x2p9reo0e"
  },
  "options": {
    "reduceOptions": {
      "values": false,
      "calcs": [
        "lastNotNull"
      ],
      "fields": ""
    },
    "orientation": "auto",
    "textMode": "name",
    "wideLayout": true,
    "colorMode": "background",
    "graphMode": "none",
    "justifyMode": "center",
    "showPercentChange": false,
    "percentChangeColorMode": "standard",
    "text": {
      "titleSize": 20
    }
  }
}
5

A bit of different approach, but have you tried using joins (build in promql)? Something like:

up{} * on(<common_label_name>) server_name{}?

(If the common label is not named the same (e.g. in metric up it’s ip and in metric server_name it’s ip_address you can rename the label by using label_replace function).

Then you can use label_join function to get the single label.

6

where does the {{ }} come from?