Get sum of values of the ongoing year

Grafana InfluxDB
1

Hello

I’m new in InfluxDB/grafana.
I ant to display the sum of a counter value since the beginning of this year.

this works, but only for 2020…

SELECT sum(“value”) as conso FROM “sensors”.“autogen”.“ESP_Eau” WHERE “topic”=‘ESP_Eau/Compteur_Eau_Pluie/Count’ AND time>=‘2020-01-01T00:00:00Z’

any other idea ?

tx