How to group by month?

Grafana InfluxDB
1

Hi experts,
I am using influxdb as data source. This is my query:
SELECT count(“TICKET_ID”) FROM “TICKET” WHERE $timeFilter GROUP BY time(30d), “TICKET_CUSTOM_FIELD_VALUE”

My questions:

  1. If I want to group by month, except using time(30d), any other workaround? Do you support something like time(1month)?
  2. Currently, I rewrite time column in influxdb by DATE_CREATED.
    Now I want to group by DATE_CLOSED(this is a field) and by month, how to implement this? Any suggestions?

Thanks for you help.

2

influxdb does the grouping, check the influxdb docs for what the group time feature supports

3

InfluxDB doesn’t support a ‘month’ (1M) as time range … nor ‘year’.
Hence the information in Grafana docs HERE is wrong or at least incomplete. Someone should mention that “M (months), y (years)” does not apply to InfluxDB.