-
1. Re: How to get the dates from a date filter
Stephen Rizzo Jul 7, 2017 12:42 PM (in response to Jenny Sanders)2 of 2 people found this helpfulDo you have a row in your data for every date between [Start Date] and [End Date]? If not, it sounds like you will need to join in a date table that does have a row for each date. If you do already have that, then you can do this with three filters. Call the field with the date for each row [Date]:
Filter 1 on calculated field [Start Date Filter] : [Date] >= [Start Date] set to TRUE
Filter 2 on calculated field [End Date Filter] : [Date] <= [End Date] set to TRUE
Filter 3 on [Date], selecting "Range of Dates". If you want this to appear as a list, make sure the pill in your filters is set to "Discrete" (blue).
-
2. Re: How to get the dates from a date filter
Jenny Sanders Jul 10, 2017 12:36 PM (in response to Jenny Sanders)Yeah, I don't have a row for every date that falls between the Start date and End Date. I am pursuing the workaround of joining a date table.
Thanks for your reply.