Calculating moving averages

Hi all,

I am trying to calculate moving averages of my daily water consumption, to display in a dashboard dial, or if need be on a graph.
My source feed is a water pulse counter in liters; I would like one value per day, which should be the average daily consumption over the last 7 days.

I can’t figure out how to achieve this with either virtual feed or graph settings?