Derivative not working in batch tick script kapacitor

InfluxDB 1 Kapacitor
,
1

I am using Derivative function to calcute bandwidth and send alert via kapacitor,

below is the query

|query(''' SELECT derivative(mean("bandwidth_in"), 1s) *8 as "value" FROM "router"."autogen"."cisco_router" where  host = '10.1.11.1' and ( interface_name = 'XXX' or  interface_name = 'XXXXX')) AND time < now() GROUP BY time(1s)  ''')
    .cluster('network')
    .period(7m)
    .every(6m)
    .groupBy(time(10s), *)

and when i try to save this tick script in chronograf i get below error.

failed to parse InfluxQL query: derivative aggregate requires a GROUP BY interval

2

Why do you have groupBy in both the query and properties? Perhaps using one or the other would be for the best.

3

I was able to resolve the issue by adding “name” fill(none) after GROUP BY time(1s) in query section.