How to create a model for a rolling 12 months period

Help
1

Hi community !

I want to build a table that contains a rolling 12 months period and that updates each 1st day of month to add the previous month that just ended and remove the oldest month to keep that rolling 12 months logic.

Snapshots doesn’t suit my need. Any idea that could ?

Thanks for your help !

2

a simple incremental logic with a delete post hook should do?

Note: @malten originally posted this reply in Slack. It might not have transferred perfectly.

3

I don’t think that would work as I need the situation at the end of the month whatever the number of situations during the month.

4

I don’t need to select everything from the last 12 month but rather to stack end of months pictures from last 12 months.

5

i’d run the model once a month (e.g on the first day of the month) and just incrementally append the latest months data , while deleting the record that falls out of the 12 month window. But maybe i’m not quite grasping the issue at hand.

Note: @malten originally posted this reply in Slack. It might not have transferred perfectly.

6

I might be able to build an incremental model set to append strategy that as you say run once a month, first day, then using a post hook, deleting the oldest month.