So i have a date column type sorted in descending order.
I want to tile it on basis of this column so i can filter out the last 30days in my dataset. Basically every date that is same must have same tile number
How can I do this?
I dont want to use datetoday comparison method for this because some dates wont be present in my dataset.
@omkarshinde
one way fo doing this
find the workflow attached
mark done if solved.
Like I said the 30 days is based upon count in my database. There can be some days missing in it which will disturb this. If there is 15,16 dates but non 17,18 i want to skip counting for those dates
@omkarshinde Can you provide some sample data and expected output for better understanding of your usecase?
More information would be very helpful! While waiting though, I will take a shot in the dark and suggest the following solution if what you need is to isolate the 30 most recent dates in your dataset:
This is a pretty simple workflow that may do what you need.