I have a dashboard which our leadership team would like the ability to click a filter to show the previous 6 months and all of the Viz's would update accordingly. For something so simple, I'm having a hard time trying to create a flag that shows the previous 6 months (or 26 weeks) of data.
All i want is something that looks like:
6 Month Filter:
Yes O
Everything I try, my results are Null, False, True
Any ideas out there?
Yeah, that changes things. All examples provided assume the date field you are looking at is a date format. Either you can convert that field to a date, or the formulas will change entirely. Date arithmetic on a non-date field will get messy in a hurry though, so I don't suggest trying to write date-centric logic over an integer/string field.
I'm assuming the index values you are referring to look something along the lines of 20170215, and not just an arbitrary identity. If so, you can right click on Integer/String field that is your date index, and change it's data type to date. Alternatively, you can derive it as a separate calculated field to preserve the original value, then apply all of the above steps to the derived field.
I'd have to see some sample data to give much more in terms of specifics.
