Running total last 12 months

[universalis]

Hi all,

I am trying to create a graph where each datapoint is the sum of the last 12 months sales. For example August is sales from Aug 2022 to Aug 2023, September is sales from Sep 2022 to Aug 2023.

I have managed to create running totals during a fixed period of time, but that is not what I need. I can't specify an offset in time using the  running_totals() command.

The data I have is time series where each datapoint has a transaction date and a sales amount.

Is this possible to do with a calculated field or a metric? 

Any help or pointers in the right direction would be appreciated!

Fred