title: Derivative not working in batch tick script kapacitor
body: <p>I am using Derivative function to calcute bandwidth and send alert via kapacitor,</p>
  
  <p>below is the query</p>
  
  <pre><code>|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 &lt; now() GROUP BY time(1s)  ''')
      .cluster('network')
      .period(7m)
      .every(6m)
      .groupBy(time(10s), *)
  </code></pre>
  
  <p>and when i try to save this tick script in chronograf i get below error.</p>
  
  <blockquote>
    <p>failed to parse InfluxQL query: derivative aggregate requires a GROUP BY interval</p>
  </blockquote>