I’m usindg grafana 8.3.3 @ Debian Linux and I created a panel with 3 SQL-Querys. I get rows of counters in a interval of 15min. If the counter is 0 I don’t get data. The result I show as stacked bars:
This look nice over last 2 days, but if I switch to last 24h not:
Here I have only data at 1 time (15:30). Why the bar is not ending and how can I bring it down?
Niels
"id": 2,
"gridPos": {
"h": 12,
"w": 18,
"x": 0,
"y": 0
},
"type": "timeseries",
"title": "Anrufe pro 15 Minuten",
"fieldConfig": {
"defaults": {
"custom": {
"drawStyle": "bars",
"lineInterpolation": "linear",
"barAlignment": 1,
"lineWidth": 2,
"fillOpacity": 40,
"gradientMode": "none",
"spanNulls": false,
"showPoints": "never",
"pointSize": 5,
"stacking": {
"mode": "normal",
"group": "A"
},
"axisPlacement": "auto",
"axisLabel": "",
"scaleDistribution": {
"type": "linear"
},
"hideFrom": {
"tooltip": false,
"viz": false,
"legend": false
},
"thresholdsStyle": {
"mode": "off"
}
},
"color": {
"mode": "palette-classic"
},
"thresholds": {
"mode": "absolute",
"steps": [
{
"color": "green",
"value": null
},
{
"color": "red",
"value": 80
}
]
},
"mappings": [],
"decimals": 0,
"displayName": "Anrufe auf Ansage 'Warteschlange voll'",
"min": 0
},
"overrides": [
{
"matcher": {
"id": "byName",
"options": "anrufe_wq_voll"
},
"properties": [
{
"id": "color",
"value": {
"fixedColor": "semi-dark-red",
"mode": "fixed"
}
}
]
},
{
"matcher": {
"id": "byName",
"options": "anrufe_aufgelegt"
},
"properties": [
{
"id": "displayName",
"value": "Anrufe in Warteschlange aufgelegt"
},
{
"id": "color",
"value": {
"fixedColor": "semi-dark-yellow",
"mode": "fixed"
}
}
]
},
{
"matcher": {
"id": "byName",
"options": "anrufe_angenommen"
},
"properties": [
{
"id": "displayName",
"value": "angenommene Anrufe"
},
{
"id": "color",
"value": {
"fixedColor": "semi-dark-green",
"mode": "fixed"
}
}
]
}
]
},
"options": {
"tooltip": {
"mode": "none"
},
"legend": {
"displayMode": "list",
"placement": "bottom",
"calcs": [
"sum"
]
}
},
"targets": [
{
"datasource": {
"type": "postgres",
"uid": "9NEqg30nz"
},
"format": "time_series",
"group": [],
"hide": false,
"metricColumn": "none",
"rawQuery": true,
"rawSql": "SELECT (round(utc_stamp/900000)*900) as time, count(guid) as Anrufe_angenommen\n\tXXX",
"refId": "angenommene Anrufe",
"select": [
[
{
"params": [
"value"
],
"type": "column"
}
]
],
"timeColumn": "time",
"where": [
{
"name": "$__timeFilter",
"params": [],
"type": "macro"
}
]
},
{
"datasource": {
"type": "postgres",
"uid": "9NEqg30nz"
},
"format": "time_series",
"group": [],
"hide": false,
"metricColumn": "none",
"rawQuery": true,
"rawSql": "SELECT (round(utc_stamp/900000)*900) as time, count(guid) as Anrufe_aufgelegt\n\tXXX",
"refId": "in Warteschlange aufgelegt",
"select": [
[
{
"params": [
"value"
],
"type": "column"
}
]
],
"timeColumn": "time",
"where": [
{
"name": "$__timeFilter",
"params": [],
"type": "macro"
}
]
},
{
"datasource": {
"type": "postgres",
"uid": "9NEqg30nz"
},
"format": "time_series",
"group": [],
"hide": false,
"metricColumn": "none",
"rawQuery": true,
"rawSql": "SELECT (round(utc_stamp/900000)*900) as time, count(guid) as Anrufe_WQ_voll\n\tXXX",
"refId": "Warteschlange voll",
"select": [
[
{
"params": [
"value"
],
"type": "column"
}
]
],
"table": "cdrs",
"timeColumn": "Zeit",
"where": []
}
],
"transparent": true,
"datasource": null
}
