How to group by month?

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

My questions:

If I want to group by month, except using time(30d), any other workaround? Do you support something like time(1month)?
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.

1 Like

This is a popular feature request and it’s on our radar.

1 Like