For anyone that may have been curious about this issue I did find a solution. The solution was to make the case for all the same as what I'm checking for. That way the boolean will always be true which is what I ultimately want for that selection. The date range filter is now working correctly as shown below.
CASE [Select Date Range]
WHEN "All" THEN DATETRUNC('month',[CALENDAR_DATE])
WHEN "3 months" THEN DATEADD('month',-3,TODAY())
WHEN "6 months" THEN DATEADD('month',-6,TODAY())
WHEN "1 year" THEN DATEADD('month',-12,TODAY())
Hi Tim, thanks for the update, I was just going to suggest replacing your first line with:
WHEN "All" THEN DATEADD('month',-1200,TODAY())
But your solution works better.
Ok, so my solution works fine with live data but I'm having a problem using this with data extracts. What is happening is we want the default view to be "Last 6 months" but when an extract is created with the filter sets it seems to only pull in that amount of data so the "Last year" and "All" do not show anything more. I thought that the filter only controlled what was disaplayed and not the data in the extract. Does anyone understand why this is happening and how to correct this issue? We are loading new data on a daily basis so the extract is generated nightly.