I’m desperately looking for ideas how to compensate this missing capability. I’m fully aware of the corresponding feature request #3991, but despite many participants the status is still unknown and I can’t wait any more. BTW I’m using Grafana where I need to use a GROUP BY (month or year),
The best idea for a work around would be to create seperate tags “month” and “year”. I assesst two ways to do it but failed:
- create those tags by my client… It’s openHAB and it won’t work. Here is the explanation why not
- use CQ to copy the original series and add month and year tags… It’s again won’t work, because I’d need a function like DATEPART in SQLserver or DATE_PART in PostgreSQL. InfluxDB doesn’t have it.
The only solution I currently see is to write my own CQ-like daemon with ie C and use HTTP API to access InfluxDB. It is however a strange solution.
Do you see any other ways ?