title: Why is this InfluxDB Flux query returning 2 tables?
body: <p>Obv. I'm new to InfluxDB &amp; the Flux query language so appreciate patience! Happy to be redirected to documentation but I haven't found anything genuinely useful to date.</p>
  <p>I've configured Jenkins (2.277.3) to push build metrics to InfluxDB (Version 2.0.5 ('7c3ead)) using plugin (<a href="https://plugins.jenkins.io/influxdb/" rel="nofollow noreferrer">https://plugins.jenkins.io/influxdb/</a>). No custom metrics at the moment. Data is being successfully sent.</p>
  <p>I'd like to build a simple bar chart to show build times for a specific project. Each &quot;bar&quot; would be an individual build (with a distinct build number). Also:</p>
  <ul>
  <li>X-axis, date/time of build</li>
  <li>Y-axis, duration of build</li>
  <li>(Ideally bars would be green/red to indicate success/anything else and would be labelled with job number. In time I'd like to add an overlay with average build time.)</li>
  </ul>
  <p>I'm trying to create the query(ies) to support this view:</p>
  <pre><code>from(bucket: &quot;db0&quot;)
    |&gt; range(start: -2d)
    |&gt; filter(fn: (r) =&gt; r[&quot;project_name&quot;] == &quot;Job2&quot;)
    |&gt; filter(fn: (r) =&gt; r._measurement == &quot;jenkins_data&quot; and r._field == &quot;build_time&quot; )
  </code></pre>
  <p>This results in 2 tables in the Table view, one for build SUCCESS and one for build FAILURE. Can someone explain to be why this is the case, and whether I'm missing some fundamental understanding of how to use the tool?</p>
  <p><a href="https://i.stack.imgur.com/dh91d.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/dh91d.png" alt="Screen snip of the data &quot;shape&quot;" /></a></p>
  <p><a href="https://i.stack.imgur.com/CnaHs.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/CnaHs.png" alt="SUCCESS table" /></a></p>
  <p><a href="https://i.stack.imgur.com/p2pOh.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/p2pOh.png" alt="FAILURE table" /></a></p>