title: Showing hourly average (histogramm) in grafana
body: <p>Given a timeseries of (electricity) marketdata with datapoints every hour, I want to show a Bar Graph with all time / time frame averages for every hour of the data, so that an analyst can easily compare actual prices to all time averages (which hour of the day is most/least expensive). </p>
  
  <p>We have cratedb as backend, which is used in grafana just like a postgres source. </p>
  
  <pre class="lang-sql prettyprint-override"><code>SELECT
    extract(HOUR from start_timestamp) as "time",
    avg(marketprice) as value
  FROM doc.el_marketprices
  GROUP BY 1
  ORDER BY 1
  </code></pre>
  
  <p>So my data basically looks like this </p>
  
  <pre><code>time    value
  23.00   23.19
  22.00   25.38
  21.00   29.93
  20.00   31.45
  19.00   34.19
  18.00   41.59
  17.00   39.38
  16.00   35.07
  15.00   30.61
  14.00   26.14
  13.00   25.20
  12.00   24.91
  11.00   26.98
  10.00   28.02
  9.00    28.73
  8.00    29.57
  7.00    31.46
  6.00    30.50
  5.00    27.75
  4.00    20.88
  3.00    19.07
  2.00    18.07
  1.00    19.43
  0       21.91
  </code></pre>
  
  <p>After hours of fiddling around with Bar Graphs, Histogramm Mode, Heatmap Panel und much more, I am just not able to draw a simple Hours-of-the day histogramm with this in Grafana. I would very much appreciate any advice on how to use any panel to get this accomplished.</p>