Code: Alles auswählen
{
"request": {
"url": "api/ds/query",
"method": "POST",
"data": {
"queries": [
{
"datasource": {
"type": "influxdb",
"uid": "HeC258Zgz"
},
"alias": "",
"query": "SELECT integral(value,1h) AS Netzbezug FROM \"Wirkleistung\" WHERE value > 0 AND $timeFilter GROUP BY time(1h) tz('Europe/Berlin')\n",
"rawQuery": true,
"refId": "A",
"resultFormat": "table",
"adhocFilters": [],
"limit": "",
"measurement": "",
"policy": "",
"slimit": "",
"tz": "",
"datasourceId": 4,
"intervalMs": 120000,
"maxDataPoints": 898
},
{
"datasource": {
"type": "influxdb",
"uid": "HeC258Zgz"
},
"alias": "",
"hide": false,
"query": "SELECT integral(value,1h) *(-1) AS Einspeisung FROM \"Wirkleistung\" WHERE value < 0 AND $timeFilter GROUP BY time(1h) tz('Europe/Berlin')\n",
"rawQuery": true,
"refId": "B",
"resultFormat": "table",
"adhocFilters": [],
"limit": "",
"measurement": "",
"policy": "",
"slimit": "",
"tz": "",
"datasourceId": 4,
"intervalMs": 120000,
"maxDataPoints": 898
},
{
"datasource": {
"type": "influxdb",
"uid": "HeC258Zgz"
},
"alias": "",
"hide": false,
"query": "SELECT integral(value,1h) AS Solarleistung FROM \"mqtt_consumer\" WHERE \"topic\" = 'solar/114184847551/0/power' AND $timeFilter GROUP BY time(1h) tz('Europe/Berlin')\n",
"rawQuery": true,
"refId": "C",
"resultFormat": "table",
"adhocFilters": [],
"limit": "",
"measurement": "",
"policy": "",
"slimit": "",
"tz": "",
"datasourceId": 4,
"intervalMs": 120000,
"maxDataPoints": 898
}
],
"range": {
"from": "2023-04-26T22:00:00.000Z",
"to": "2023-04-27T21:59:59.999Z",
"raw": {
"from": "now/d",
"to": "now/d"
}
},
"from": "1682546400000",
"to": "1682632799999"
},
"hideFromInspector": false
},
"response": {
"results": {
"A": {
"status": 200,
"frames": [
{
"schema": {
"name": "Wirkleistung.Netzbezug",
"refId": "A",
"meta": {
"executedQueryString": "SELECT integral(value,1h) AS Netzbezug FROM \"Wirkleistung\" WHERE value > 0 AND time >= 1682546400000ms and time <= 1682632799999ms GROUP BY time(1h) tz('Europe/Berlin')\n"
},
"fields": [
{
"name": "time",
"type": "time",
"typeInfo": {
"frame": "time.Time"
}
},
{
"name": "value",
"type": "number",
"typeInfo": {
"frame": "float64",
"nullable": true
},
"config": {
"displayNameFromDS": "Wirkleistung.Netzbezug"
}
}
]
},
"data": {
"values": [
[
1682546400000,
1682550000000,
1682553600000,
1682557200000,
1682560800000,
1682564400000,
1682568000000,
1682571600000,
1682575200000,
1682578800000,
1682582400000,
1682586000000,
1682589600000,
1682593200000,
1682596800000,
1682600400000,
1682604000000
],
[
163.2268879129128,
165.00983633623187,
171.18451989414058,
157.35777073325661,
219.02438471820182,
201.60438460946008,
499.0586685698154,
407.940036900423,
145.6010666028592,
699.3783391810291,
1100.4875046665488,
1718.8761278006916,
1618.5680526616698,
1436.650573973823,
1079.817903441494,
1422.1393822116383,
292.63843409135706
]
]
}
}
],
"refId": "A"
},
"B": {
"status": 200,
"frames": [
{
"schema": {
"name": "Wirkleistung.Einspeisung",
"refId": "B",
"meta": {
"executedQueryString": "SELECT integral(value,1h) *(-1) AS Einspeisung FROM \"Wirkleistung\" WHERE value < 0 AND time >= 1682546400000ms and time <= 1682632799999ms GROUP BY time(1h) tz('Europe/Berlin')\n"
},
"fields": [
{
"name": "time",
"type": "time",
"typeInfo": {
"frame": "time.Time"
}
},
{
"name": "value",
"type": "number",
"typeInfo": {
"frame": "float64",
"nullable": true
},
"config": {
"displayNameFromDS": "Wirkleistung.Einspeisung"
}
}
]
},
"data": {
"values": [
[
1682575200000,
1682578800000,
1682582400000,
1682586000000,
1682589600000,
1682593200000,
1682596800000,
1682600400000,
1682604000000
],
[
2.292733227228737,
144.59332943781365,
234.94247215638575,
288.4223708068328,
300.1699989706583,
322.05376274556784,
100.09165953989718,
206.7113878546771,
40.89049276093858
]
]
}
}
],
"refId": "B"
},
"C": {
"status": 200,
"frames": [
{
"schema": {
"name": "mqtt_consumer.Solarleistung",
"refId": "C",
"meta": {
"executedQueryString": "SELECT integral(value,1h) AS Solarleistung FROM \"mqtt_consumer\" WHERE \"topic\" = 'solar/114184847551/0/power' AND time >= 1682546400000ms and time <= 1682632799999ms GROUP BY time(1h) tz('Europe/Berlin')\n"
},
"fields": [
{
"name": "time",
"type": "time",
"typeInfo": {
"frame": "time.Time"
}
},
{
"name": "value",
"type": "number",
"typeInfo": {
"frame": "float64",
"nullable": true
},
"config": {
"displayNameFromDS": "mqtt_consumer.Solarleistung"
}
}
]
},
"data": {
"values": [
[
1682568000000,
1682571600000,
1682575200000,
1682578800000,
1682582400000,
1682586000000,
1682589600000,
1682593200000,
1682596800000,
1682600400000,
1682604000000
],
[
7.498925664396776,
63.261003525552745,
150.33863637633908,
349.1861915754702,
461.17841999245644,
503.8499277558381,
537.6618744605187,
529.4523052386745,
313.89669524467087,
487.98053223548936,
210.80122171518374
]
]
}
}
],
"refId": "C"
}
}
}
}
Aber A, B und C liefern unterschiedliche Anzahlen von Datensätzen. Das könnte für die anschließende Transformierung ein Problem sein.