2 Replies Latest reply on Jun 6, 2018 12:58 PM by Tyler McDonald

    Creating date filter that automatically starts today and ends on the 1st of the month a year ago? Tableau 10.5.4

    Tyler McDonald

      So the question pretty much describes exactly what I'm looking to do. I'd like to create a date filter where users can expand the range as much as they'd like. However, I'd like it to be on a rolling basis. I realize the Relative Dates in Tableau function is similar, but it's not exactly what I'd like to do and doesn't contain all the functionality I'm looking for. Pretty much if today's date is 6/6/2018, I'd like the filter to go from 6/1/2017-6/6/2018. Instead of just starting at 6/6/2017, it rounds down to the 1st of that month. Is there anyway to do this? I've been reading through the forums and couldn't find an exact answer.

       

      Thanks in advance!