title: Prometheus query per day not in 24h "buckets"
body: <p>I have a prometheus instance with grafana as UI and I want to have a graph that sums a rate of a gauge.</p>
  <p>Right now I have something like:</p>
  <pre><code>sum(rate(myNiceMetric[1d])*60*60*24) by (result,component)
  </code></pre>
  <p>But the problem is that the rate time window covers the last 24h, but to have stable numbers I need it to be by day (00:00-24:00)</p>
  <p>Is there a way to achieve that?</p>