Zum Inhalt springen

Schlagwort: influxdb


Kategorien:

InfluxDB uselful queries

Beitrags Datum:
Autor:
Schlagwörter:
Anzahl Kommentare: keine Kommentare

Show all available databasesshow databases Use a database e.g mydbuse mydb Show available fields and their type of a a databaseshow field keys Show series where xyzshow series where "powermeter" = 'xyzzz' Calculate difference between the two latest values of two daysSELECT difference(last(total_kWh)) FROM power_total WHERE time >0 AND "powerMeter" = 'xyz' GROUP BY time(1d) Select the latest entries from a field within a timespan of 2 daysselect […]