Only 13 months data at any point in time

[aish28warya]

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.

[Sebastiaandb]

Hi @aish28warya ,

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

[aish28warya]

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?

[aish28warya · Accepted solution]

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.