Grafana Cumulative Line

[ejg3855]

I could look over in the grafana group but I thought it would be relevant here.

Instead of the daily dollar totals as a line, which is directly correlated to the kwh used so its sort of irrelevant or redundant from a visual representation need. How can I make this data set a cumulative line that shows a 60 day time series ? So basically I want to see my $ increase in the same terms as my billing cycle.

SELECT sum("energy") * [[cost_per_kWh]] FROM "rp_5min"."net_energy_5m" WHERE time > now() - 60d GROUP BY time(1d) tz('${timezone}')