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”
- 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.