Schlagwort: influxdb

InfluxDB uselful queries

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 […]