Skip to content

Instantly share code, notes, and snippets.

@latonita
Last active April 24, 2024 14:28
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save latonita/3108b661783e55cbf3f071ee64997dd9 to your computer and use it in GitHub Desktop.
Save latonita/3108b661783e55cbf3f071ee64997dd9 to your computer and use it in GitHub Desktop.
influxdb - loading meter readings
#group false false false false true true true true true true true true true
#datatype string long dateTime:RFC3339 double string string string string string string string string string
#default mean
result table _time _value _field _measurement tariff domain location source month year yearMonth
2023-01-26T12:00:00Z 98114000 value energy T1 sensor country_house power-meter-total 1 2023 202301
2023-01-26T12:00:00Z 45426000 value energy T2 sensor country_house power-meter-total 1 2023 202301
2023-02-25T12:00:00Z 100411000 value energy T1 sensor country_house power-meter-total 2 2023 202302
2023-02-25T12:00:00Z 46548000 value energy T2 sensor country_house power-meter-total 2 2023 202302
2023-03-26T12:00:00Z 102708000 value energy T1 sensor country_house power-meter-total 3 2023 202303
2023-03-26T12:00:00Z 47670000 value energy T2 sensor country_house power-meter-total 3 2023 202303
2023-04-24T12:00:00Z 104162000 value energy T1 sensor country_house power-meter-total 4 2023 202304
2023-04-24T12:00:00Z 48372000 value energy T2 sensor country_house power-meter-total 4 2023 202304
2023-05-31T12:00:00Z 104747000 value energy T1 sensor country_house power-meter-total 5 2023 202305
2023-05-31T12:00:00Z 48644000 value energy T2 sensor country_house power-meter-total 5 2023 202305
2023-06-26T12:00:00Z 105158000 value energy T1 sensor country_house power-meter-total 6 2023 202306
2023-06-26T12:00:00Z 48863000 value energy T2 sensor country_house power-meter-total 6 2023 202306
2023-07-31T12:00:00Z 105593000 value energy T1 sensor country_house power-meter-total 7 2023 202307
2023-07-31T12:00:00Z 49078000 value energy T2 sensor country_house power-meter-total 7 2023 202307
2023-08-25T12:00:00Z 105962000 value energy T1 sensor country_house power-meter-total 8 2023 202308
2023-08-25T12:00:00Z 49240000 value energy T2 sensor country_house power-meter-total 8 2023 202308
2023-09-24T12:00:00Z 106479000 value energy T1 sensor country_house power-meter-total 9 2023 202309
2023-09-24T12:00:00Z 49488000 value energy T2 sensor country_house power-meter-total 9 2023 202309
2023-10-24T12:00:00Z 107352000 value energy T1 sensor country_house power-meter-total 10 2023 202310
2023-10-24T12:00:00Z 49859000 value energy T2 sensor country_house power-meter-total 10 2023 202310
2023-11-30T12:00:00Z 108997000 value energy T1 sensor country_house power-meter-total 11 2023 202311
2023-11-30T12:00:00Z 50630000 value energy T2 sensor country_house power-meter-total 11 2023 202311
2023-12-25T12:00:00Z 112849600 value energy T1 sensor country_house power-meter-total 12 2023 202312
2023-12-25T12:00:00Z 52554200 value energy T2 sensor country_house power-meter-total 12 2023 202312
2024-01-25T12:00:00Z 115418000 value energy T1 sensor country_house power-meter-total 1 2024 202401
2024-01-25T12:00:00Z 53837000 value energy T2 sensor country_house power-meter-total 1 2024 202401
2024-02-23T12:00:00Z 118411000 value energy T1 sensor country_house power-meter-total 2 2024 202402
2024-02-23T12:00:00Z 55320000 value energy T2 sensor country_house power-meter-total 2 2024 202402
2024-03-24T12:00:00Z 120997000 value energy T1 sensor country_house power-meter-total 3 2024 202403
2024-03-24T12:00:00Z 56584000 value energy T2 sensor country_house power-meter-total 3 2024 202403
2024-04-24T12:00:00Z 122911000 value energy T1 sensor country_house power-meter-total 4 2024 202404
2024-04-24T12:00:00Z 57572000 value energy T2 sensor country_house power-meter-total 4 2024 202404
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment