title: How to debug batch query in Kapacitor
body: <p>As I understand in log we can see only discrete values and can not see table of values in series</p>
  
  <p>with any aggregation functions</p>
  
  <pre><code>batch
      |query('''SELECT sum("gauge") ***  ''')
      ***
      |mean('sum_gauge')
      |log()
  </code></pre>
  
  <p>log() return Kapacitor point with value</p>
  
  <p>but without:</p>
  
  <pre><code>batch
      |query('''SELECT sum("gauge") ***  ''')
          .period(1h)
          .every(10s)
          .align()
          .groupBy(time(15m),'host')
          .fill(0)
      |log()
  </code></pre>
  
  <p>show only </p>
  
  <pre><code>2018-05-10T13:19:20.084Z
  kapacitor
  begin batch
  2018-05-10T13:19:20.084Z
  kapacitor
  batch point
  2018-05-10T13:19:20.084Z
  kapacitor
  batch point
  2018-05-10T13:19:20.084Z
  kapacitor
  batch point
  </code></pre>
  
  <p>according <a href="https://github.com/influxdata/chronograf/blob/1.4.4.2/ui/src/kapacitor/components/LogsTableRow.js#L44" rel="nofollow noreferrer">https://github.com/influxdata/chronograf/blob/1.4.4.2/ui/src/kapacitor/components/LogsTableRow.js#L44</a>
  we will see that only "msg" field displayed in chronograf UI</p>
  
  <p>but log has more info (you can see it using <code>kapacitor watch &lt;task_id&gt;</code>), for example:</p>
  
  <pre><code>ts=2018-05-10T14:50:40.011Z lvl=info msg="batch point" service=kapacitor task_master=main task=14860f8d-8b6d-48d4-a7fc-b5cbea717b37 node=log3 prefix= name=cpu group=host=*** tag_host=*** field_*=*** time=2018-05-10T14:50:00Z
  </code></pre>
  
  <hr>
  
  <p>Maybe someone know method or instrument how to debug such queries (batch)?</p>
  
  <p>Because in other monitoring stack it's possible to create graph with preprocessed points in alert
  example #bosun</p>
  
  <p><a href="https://i.stack.imgur.com/CEd9O.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/CEd9O.png" alt="enter image description here"></a></p>
  
  <p>"Alert rule builder" in chronograf looks like what I need but it has very limited functionality and you can not create sophisticated alerts (e.g with joins)</p>