Thanks! Let me provide some more details:
-
I’m using InfluxQL. btw: for a beginner, but not a computer noob, what do you recommend? Should I switch to Flux right from the start?
-
Query: SELECT "value" FROM "dwd.0.warnings_all" WHERE time >= now() - 24h and time <= now()
-
Output: Screenshot, 2022-02-26 11:52:11 - Paste.Pics
Full panel JSON:
{
"id": 44,
"gridPos": {
"h": 13,
"w": 24,
"x": 0,
"y": 17
},
"type": "table",
"title": "DWD JSON",
"transformations": [
{
"id": "extractFields",
"options": {
"format": "auto",
"replace": true,
"source": "dwd.0.warnings_all"
}
},
{
"id": "organize",
"options": {
"excludeByName": {
"altitudeEnd": true,
"altitudeStart": true,
"description": false,
"headline": true,
"instruction": true,
"regionName": true,
"state": true,
"stateShort": true,
"type": true
},
"indexByName": {
"altitudeEnd": 12,
"altitudeStart": 11,
"description": 5,
"end": 2,
"event": 3,
"headline": 4,
"instruction": 9,
"level": 0,
"regionName": 6,
"start": 1,
"state": 7,
"stateShort": 10,
"type": 8
},
"renameByName": {
"description": "Beschreibung",
"end": "Ende",
"event": "Ereignis",
"headline": "Details",
"instruction": "",
"level": "Schwere",
"start": "Beginn"
}
}
},
{
"id": "convertFieldType",
"options": {
"conversions": [
{
"destinationType": "time",
"targetField": "start"
},
{
"dateFormat": "",
"destinationType": "time",
"targetField": "end"
}
],
"fields": {}
}
},
{
"id": "sortBy",
"options": {
"fields": {},
"sort": [
{
"desc": true,
"field": "Beginn"
}
]
}
},
{
"id": "filterByValue",
"options": {
"filters": [
{
"config": {
"id": "isNull",
"options": {}
},
"fieldName": "Schwere"
}
],
"match": "any",
"type": "exclude"
}
}
],
"pluginVersion": "8.4.2",
"fieldConfig": {
"defaults": {
"custom": {
"align": "left",
"displayMode": "auto",
"filterable": false
},
"mappings": [
{
"options": {
"3": {
"color": "orange",
"index": 0,
"text": "Erhöht"
}
},
"type": "value"
},
{
"options": {
"from": 0,
"result": {
"color": "green",
"index": 1,
"text": "Niedrig"
},
"to": 2
},
"type": "range"
},
{
"options": {
"from": 4,
"result": {
"color": "red",
"index": 2,
"text": "Hoch"
},
"to": 4
},
"type": "range"
},
{
"options": {
"from": 5,
"result": {
"color": "dark-purple",
"index": 3,
"text": "Gefahr"
},
"to": 20
},
"type": "range"
}
],
"thresholds": {
"mode": "absolute",
"steps": [
{
"color": "green",
"value": null
}
]
},
"color": {
"mode": "thresholds"
}
},
"overrides": [
{
"matcher": {
"id": "byName",
"options": "Beginn"
},
"properties": [
{
"id": "unit",
"value": "time: DD.MM.YYYY HH:mm"
}
]
},
{
"matcher": {
"id": "byName",
"options": "Ende"
},
"properties": [
{
"id": "unit",
"value": "time: DD.MM.YYYY HH:mm"
}
]
},
{
"matcher": {
"id": "byName",
"options": "Schwere"
},
"properties": [
{
"id": "custom.displayMode",
"value": "color-background-solid"
},
{
"id": "custom.width",
"value": 100
},
{
"id": "custom.align",
"value": "center"
}
]
},
{
"matcher": {
"id": "byName",
"options": "Ereignis"
},
"properties": [
{
"id": "custom.width",
"value": 219
}
]
},
{
"matcher": {
"id": "byType",
"options": "time"
},
"properties": [
{
"id": "custom.width",
"value": 160
}
]
}
]
},
"options": {
"showHeader": true,
"footer": {
"show": false,
"reducer": [
"sum"
],
"fields": ""
},
"sortBy": [
{
"desc": true,
"displayName": "Ende"
}
]
},
"targets": [
{
"datasource": {
"type": "influxdb",
"uid": "UJIzjoJ7z"
},
"groupBy": [],
"hide": false,
"measurement": "dwd.0.warnings_all",
"orderByTime": "ASC",
"policy": "default",
"refId": "A",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"value"
],
"type": "field"
}
]
],
"tags": []
}
],
"datasource": null
}
So please bear with me.
Just to explain it. The data is in one json string which I then transform to the columns. This is the raw data: 
)
Also when I open it in Firefox, it reports an error.