Only 13 months data at any point in time

Hi all,

I'm creating a database that keeps adding current month data to it.

Output file is .hyper because we want Tableau visualizations as well.

I want to create something that ensures at any given point in time, the output file only has 13 months of data.

For example if I'm in Jan-21 than it should have data from Jan-20 till Jan-21.

If I move to Feb-21, than it should have Feb-20 till Feb-21. and so on.

Datasets

Date Time

Accepted answers

I actually found the answer.

The below workflow works perfect. A lil bit help from @Sebastiaandb as well. A bit work I did myself. All in all now it works perfect.

See attached. Also May month is missing from my dummy input which is a mistake.

You might want to consider making a date column. The date variable in my filter expression would be your date variable.

This will only take records from the current month + the 12 months before it.

Because the reference for the formula is the current datetime, it will dynamically change from month to month.

I hope it helps!

Greetings,

Seb

Hi, thank you so much for below solution.

I'm sharing my workflow with you which also has the sample data set. Currently I'm trying to work it out with 7 months.

But not sure it's not working properly.

Could I request you to please also explain the formulae you've used in your filter tool?