Influxql "group by time(time_interval, offset_interval)

1

Hi,

I am creating a query to select count and group by time with time_interval and offset_interval. However, I have about 30 different offset_intervals. To visualize all the 30 different offset_intervals, I need to create 30 queries. Is there a way to reduce 30 queries to just one query with 30 different offset_intervals or even more elegant query?

2

Hello @lihtian285,
Welcome! Unofrtunately, no there isn’t a way to do this with InfluxQL. You make the query more elegant do this with Flux though because you can define custom functions.