I’m using grafana 7.0.5 with Prometheus and Redis.
I have defined a table panel, but for some reason it doesn’t display all the rows it should display. When I do inspect->query, I see all the elements. When I do inspect->data, it doesn’t show all the data, but when I download the data as CSV, all the data is there.
The panel also does not have a vertical scroll bar and I don’t see where to add it.
Here is the json of the panel. I would appreciate any help. Thanks.
{
"cacheTimeout": null,
"fieldConfig": {
"defaults": {
"custom": {
"align": "left",
"displayMode": "color-background"
},
"unit": "none",
"thresholds": {
"mode": "absolute",
"steps": [
{
"color": "green",
"value": null
},
{
"color": "red",
"value": 1
}
]
},
"mappings": [
{
"id": 0,
"op": "=",
"text": "Active",
"type": 1,
"value": "0"
}
],
"links": [
{
"targetBlank": true,
"title": "Go to ${__data.fields[0]} DB Dashboard ",
"url": "/d/D_Dersdb-dashboard?orgId=1&refresh=10s&${__url_time_range}&var-cluster=${cluster}&var-bdb_name=${__data.fields[0]}\r\n"
}
],
"nullValueMode": "connected"
},
"overrides": [
{
"matcher": {
"id": "byName",
"options": "Database Status"
},
"properties": [
{
"id": "custom.width",
"value": 150
},
{
"id": "custom.align",
"value": "center"
}
]
}
]
},
"gridPos": {
"h": 6,
"w": 7,
"x": 3,
"y": 1
},
"id": 166,
"interval": null,
"links": [],
"maxDataPoints": 100,
"options": {
"showHeader": true,
"sortBy": []
},
"pluginVersion": "7.0.5",
"targets": [
{
"expr": "count(bdb_up{cluster=\"$cluster\"}) by (bdb_name) - count(bdb_up{cluster=\"$cluster\",status=\"active\"}) by (bdb_name) ",
"instant": true,
"interval": "",
"intervalFactor": 1,
"legendFormat": "{{bdb_name}}",
"refId": "A"
}
],
"timeFrom": null,
"timeShift": null,
"title": "DBs Status",
"transformations": [
{
"id": "seriesToColumns",
"options": {}
},
{
"id": "reduce",
"options": {
"reducers": [
"last"
]
}
},
{
"id": "organize",
"options": {
"excludeByName": {},
"indexByName": {},
"renameByName": {
"Field": "Database Name",
"Last": "Database Status"
}
}
}
],
"type": "table",
"datasource": null
}