yesoreyeram/yesoreyeram-boomtable-panel

Multiple metrics on a single row not working with InfluxDB

lenny1972 opened this issue · 0 comments

lenny1972 commented

Describe the bug
After migrating my datasource from InfluxDB 1.8 to InfluxDB 2.0 (with FLUX query language) even if in the different "Pattern" configuration tabs I always define the same Row Name ("0") the different metrics (Pompa, Ventola Destra, Ventola Sinistra and so on..) are not displayed in the same row.

Version Details:

  • Grafana version : 7.5.1 (official docker image)
  • Plugin version : v.1.4.0
  • Did this work in any other version of Grafana : it worked with a Grafana docker image 7.0.5 version, InfluxDB official docker image 1.8 and yesoreyeram-boomtable-panel v 1.3.0
  • What datasource you use : InfluxDB (official docker image 2.0) using FLUX query language.

Panel JSON
{
"datasource": "InfluxDB",
"defaultPattern": {
"bgColors": "green|orange|red",
"col_name": "Colonna",
"decimals": 2,
"delimiter": ".",
"enable_bgColor": false,
"enable_time_based_thresholds": false,
"enable_transform": false,
"filter": {
"value_above": "",
"value_below": ""
},
"format": "none",
"null_color": "darkred",
"null_value": "No data",
"row_name": "0",
"thresholds": "70,90",
"time_based_thresholds": [],
"transform_values": "value|value|value",
"valueName": "current"
},
"default_title_for_rows": "Dispositivo",
"fieldConfig": {
"defaults": {},
"overrides": []
},
"gridPos": {
"h": 4,
"w": 13,
"x": 5,
"y": 17
},
"hideTimeOverride": true,
"hide_first_column": true,
"id": 142,
"links": [],
"nullPointMode": "connected",
"patterns": [
{
"bgColors": "red|green",
"col_name": "Pompa",
"decimals": 2,
"delimiter": ".",
"enable_bgColor": true,
"enable_time_based_thresholds": false,
"enable_transform": true,
"filter": {
"value_above": "",
"value_below": ""
},
"format": "none",
"name": "Pompa",
"null_color": "darkred",
"null_value": "No data",
"pattern": "PMP",
"row_name": "0",
"thresholds": "1",
"time_based_thresholds": [],
"tooltipTemplate": "-",
"transform_values": "SPENTA|ACCESA",
"valueName": "current"
},
{
"bgColors": "red|green",
"col_name": "Ventola Destra",
"decimals": 2,
"delimiter": ".",
"enable_bgColor": true,
"enable_time_based_thresholds": false,
"enable_transform": true,
"filter": {
"value_above": "",
"value_below": ""
},
"format": "none",
"name": "Ventola Destra",
"null_color": "darkred",
"null_value": "No data",
"pattern": "VTL_DX",
"row_name": "0",
"thresholds": "1",
"time_based_thresholds": [],
"tooltipTemplate": "-",
"transform_values": "SPENTA|ACCESA",
"valueName": "current"
},
{
"bgColors": "red|green",
"col_name": "Ventola Sinistra",
"decimals": 2,
"delimiter": ".",
"enable_bgColor": true,
"enable_time_based_thresholds": false,
"enable_transform": true,
"filter": {
"value_above": "",
"value_below": ""
},
"format": "none",
"name": "Ventola Sinistra",
"null_color": "darkred",
"null_value": "No data",
"pattern": "VTL_SX",
"row_name": "0",
"thresholds": "1",
"time_based_thresholds": [],
"tooltipTemplate": "-",
"transform_values": "SPENTA|ACCESA",
"valueName": "current"
},
{
"bgColors": "green|red",
"col_name": "Eletrovalvola Manifold",
"decimals": 2,
"delimiter": ".",
"enable_bgColor": true,
"enable_time_based_thresholds": false,
"enable_transform": true,
"filter": {
"value_above": "",
"value_below": ""
},
"format": "none",
"name": "Eletrovalvola Manifold",
"null_color": "darkred",
"null_value": "No data",
"pattern": "ELV_M",
"row_name": "0",
"thresholds": "1",
"time_based_thresholds": [],
"tooltipTemplate": "NOTA: L'operazione di chiusura/apertura della valvola può durare dai 5 ai 7 secondi",
"transform_values": "APERTA|CHIUSA",
"valueName": "current"
},
{
"bgColors": "green|red",
"col_name": "Elettrovalvola di Carico",
"decimals": 2,
"delimiter": ".",
"enable_bgColor": true,
"enable_time_based_thresholds": false,
"enable_transform": true,
"filter": {
"value_above": "",
"value_below": ""
},
"format": "none",
"name": "Elettrovalvola di Carico",
"null_color": "darkred",
"null_value": "No data",
"pattern": "ELV_C",
"row_name": "0",
"thresholds": "1",
"time_based_thresholds": [],
"tooltipTemplate": "NOTA: L'operazione di chiusura/apertura della valvola può durare dai 5 ai 7 secondi",
"transform_values": "CHIUSA|APERTA",
"valueName": "current"
},
{
"bgColors": "green|red",
"col_name": "Elettrovalvola di Scarico",
"decimals": 2,
"delimiter": ".",
"enable_bgColor": true,
"enable_time_based_thresholds": false,
"enable_transform": true,
"filter": {
"value_above": "",
"value_below": ""
},
"format": "none",
"name": "Elettrovalvola di Scarico",
"null_color": "darkred",
"null_value": "No data",
"pattern": "ELV_S",
"row_name": "0",
"thresholds": "1",
"time_based_thresholds": [],
"tooltipTemplate": "NOTA: L'operazione di chiusura/apertura della valvola può durare dai 5 ai 7 secondi",
"transform_values": "CHIUSA|APERTA",
"valueName": "current"
},
{
"bgColors": "red|green",
"bgColors_overrides": "0->green|2->red|1->yellow",
"clickable_cells_link": "",
"col_name": "Lampada UV",
"decimals": 2,
"delimiter": ".",
"enable_bgColor": true,
"enable_bgColor_overrides": false,
"enable_clickable_cells": false,
"enable_textColor": false,
"enable_textColor_overrides": false,
"enable_time_based_thresholds": false,
"enable_transform": true,
"enable_transform_overrides": false,
"filter": {
"value_above": "",
"value_below": ""
},
"format": "none",
"name": "Lampada UV",
"null_color": "darkred",
"null_textcolor": "black",
"null_value": "No data",
"pattern": "UV",
"row_col_wrapper": "",
"row_name": "0",
"textColors": "red|orange|green",
"textColors_overrides": "0->red|2->green|1->yellow",
"thresholds": "1",
"time_based_thresholds": [],
"tooltipTemplate": "-",
"transform_values": "SPENTA|ACCESA",
"transform_values_overrides": "0->down|1->up",
"valueName": "current"
},
{
"bgColors": "green|red|orange",
"bgColors_overrides": "0->green|2->red|1->yellow",
"clickable_cells_link": "",
"col_name": "Autolivellamento",
"decimals": "0",
"delimiter": ".",
"enable_bgColor": true,
"enable_bgColor_overrides": false,
"enable_clickable_cells": false,
"enable_textColor": false,
"enable_textColor_overrides": false,
"enable_time_based_thresholds": false,
"enable_transform": true,
"enable_transform_overrides": false,
"filter": {
"value_above": "",
"value_below": ""
},
"format": "none",
"name": "Autolivellamento",
"null_color": "darkred",
"null_textcolor": "black",
"null_value": "No data",
"pattern": "A-LVL",
"row_col_wrapper": "",
"row_name": "0",
"textColors": "red|orange|green",
"textColors_overrides": "0->red|2->green|1->yellow",
"thresholds": "1,3",
"time_based_thresholds": [],
"tooltipTemplate": "-",
"transform_values": "ABILITATO|LIVELLAMENTO IN CORSO|DISABILITATO",
"transform_values_overrides": "0->down|1->up",
"valueName": "current"
}
],
"plugin_title": "Boom Table",
"row_col_wrapper": "_",
"sorting_props": {
"col_index": -1,
"direction": "desc"
},
"targets": [
{
"groupBy": [],
"hide": false,
"measurement": "stato",
"orderByTime": "ASC",
"policy": "autogen",
"query": "from(bucket: "APA")\r\n |> range(start: v.timeRangeStart, stop: v.timeRangeStop)\r\n |> filter(fn: (r) => r["_measurement"] == "stato")\r\n |> filter(fn: (r) => r["APA"] == "${APA}")\r\n |> filter(fn: (r) => r["_field"] == "PMP")\r\n |> last()",
"refId": "PMP",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"PMP"
],
"type": "field"
}
]
],
"tags": [
{
"key": "APA",
"operator": "=",
"value": "$APA"
}
]
},
{
"groupBy": [],
"measurement": "stato",
"orderByTime": "ASC",
"policy": "autogen",
"query": "from(bucket: "APA")\r\n |> range(start: v.timeRangeStart, stop: v.timeRangeStop)\r\n |> filter(fn: (r) => r["_measurement"] == "stato")\r\n |> filter(fn: (r) => r["APA"] == "${APA}")\r\n |> filter(fn: (r) => r["_field"] == "VTL_DX")\r\n |> last()",
"refId": "VTL_DX",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"VTL_SX"
],
"type": "field"
}
]
],
"tags": [
{
"key": "APA",
"operator": "=",
"value": "$APA"
}
]
},
{
"groupBy": [],
"measurement": "stato",
"orderByTime": "ASC",
"policy": "autogen",
"query": "from(bucket: "APA")\r\n |> range(start: v.timeRangeStart, stop: v.timeRangeStop)\r\n |> filter(fn: (r) => r["_measurement"] == "stato")\r\n |> filter(fn: (r) => r["APA"] == "${APA}")\r\n |> filter(fn: (r) => r["_field"] == "VTL_SX")\r\n |> last()",
"refId": "VTL_SX",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"VTL_DX"
],
"type": "field"
}
]
],
"tags": [
{
"key": "APA",
"operator": "=",
"value": "$APA"
}
]
},
{
"groupBy": [],
"measurement": "stato",
"orderByTime": "ASC",
"policy": "autogen",
"query": "from(bucket: "APA")\r\n |> range(start: v.timeRangeStart, stop: v.timeRangeStop)\r\n |> filter(fn: (r) => r["_measurement"] == "stato")\r\n |> filter(fn: (r) => r["APA"] == "${APA}")\r\n |> filter(fn: (r) => r["_field"] == "ELV_M")\r\n |> last()",
"refId": "ELV_M",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"ELV_C"
],
"type": "field"
}
]
],
"tags": [
{
"key": "APA",
"operator": "=",
"value": "$APA"
}
]
},
{
"groupBy": [],
"measurement": "stato",
"orderByTime": "ASC",
"policy": "autogen",
"query": "from(bucket: "APA")\r\n |> range(start: v.timeRangeStart, stop: v.timeRangeStop)\r\n |> filter(fn: (r) => r["_measurement"] == "stato")\r\n |> filter(fn: (r) => r["APA"] == "${APA}")\r\n |> filter(fn: (r) => r["_field"] == "ELV_C")\r\n |> last()",
"refId": "ELV_C",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"ELV_S"
],
"type": "field"
}
]
],
"tags": [
{
"key": "APA",
"operator": "=",
"value": "$APA"
}
]
},
{
"groupBy": [],
"measurement": "stato",
"orderByTime": "ASC",
"policy": "autogen",
"query": "from(bucket: "APA")\r\n |> range(start: v.timeRangeStart, stop: v.timeRangeStop)\r\n |> filter(fn: (r) => r["_measurement"] == "stato")\r\n |> filter(fn: (r) => r["APA"] == "${APA}")\r\n |> filter(fn: (r) => r["_field"] == "ELV_S")\r\n |> last()",
"refId": "ELV_S",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"ELV_M"
],
"type": "field"
}
]
],
"tags": [
{
"key": "APA",
"operator": "=",
"value": "$APA"
}
]
},
{
"groupBy": [],
"measurement": "stato",
"orderByTime": "ASC",
"policy": "autogen",
"query": "from(bucket: "APA")\r\n |> range(start: v.timeRangeStart, stop: v.timeRangeStop)\r\n |> filter(fn: (r) => r["_measurement"] == "stato")\r\n |> filter(fn: (r) => r["APA"] == "${APA}")\r\n |> filter(fn: (r) => r["_field"] == "UV")\r\n |> last()",
"refId": "UV",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"UV"
],
"type": "field"
}
]
],
"tags": [
{
"key": "APA",
"operator": "=",
"value": "$APA"
}
]
},
{
"groupBy": [],
"measurement": "stato",
"orderByTime": "ASC",
"policy": "autogen",
"query": "from(bucket: "APA")\r\n |> range(start: v.timeRangeStart, stop: v.timeRangeStop)\r\n |> filter(fn: (r) => r["_measurement"] == "stato")\r\n |> filter(fn: (r) => r["APA"] == "${APA}")\r\n |> filter(fn: (r) => r["_field"] == "A-LVL")\r\n |> last()",
"refId": "A-LVL",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"A-LVL"
],
"type": "field"
}
]
],
"tags": [
{
"key": "APA",
"operator": "=",
"value": "$APA"
}
]
}
],
"timeFrom": "60s",
"title": "Stato delle uscite dell'$APA",
"transformations": [],
"type": "yesoreyeram-boomtable-panel",
"activePatternIndex": 0,
"debug_mode": false,
"hide_headers": false,
"maxDataPoints": ""
}

Screenshots
This is the problema I'm having in the Panel

panel error

And these are the screenshot of some patterns configuration. In the red ellipses always the same reference of Row Name ("0")...
pattern#1_configuration
pattern#2_configuration
pattern#3_configuration

I'm not so skilled in InfluxDB 2.0 and FLUX query language, but (due to the fact that this panel worked regularly with InfluxDB 1.8) it seems to me that InfluxDB 2.0 didn't support "Row Name" confiiguration anymore...