Will this keep only dates that are today?
The reason I have kept it a discrete date field is because we want users to be able to see the default of today upon opening the workbook, but then have the ability to manipulate the date to another specific day.
((Side note:: we have some date fields set up as parameters instead of the above mentioned filters. Would these undergo a completely separate process for setting a default of today? Is this considered an example of the dynamic parameter?))
Yes that will keep dates that are only today.
To your second point, what I have done in situations like this is create a "Select Range" parameter, and a "Select Date" date parameter
Select Range =>
Select Date Parameter =>
This allows the user to type in whatever day they need to see. In addition, this avoids me having to manually update the Date list everyday....
I then tie these two parameters into a calculated field
IIF([Select Range] = 'Today'
, [Date] = TODAY()
, IIF([Select Range] = 'Select Date'
, [Date] = [Select Date]
, FALSE )
Put that onto your filter shelf and select true.
This checks to see it the First Parameter (Select Range) is set to 'Today', if it is, then my Date must equal today. If, however Select Range is set to 'Select Date', then my date must be equal to the Select Date Parameter.
Your user will have to toggle from Today to Select Date in the Parameter, but it gives you the functionality you are looking for (I hope).
I built the attached .twbx using a modified SuperStore data set (dates through 2016!) that implements this solution.
A Boolean Parameter is used to allow the customer to base the filtered date range on Today' date (TRUE) or use the Start/End dates from the Parameter.
This is a pretty clever way to address this need to default to today AND allow user control over Start-End filter dates.
And a Hat-tip to the presenter of the TC15 Session - Risky Business No More at Axis Capital: Enterprise Analytics in the Insurance Industry - for the details on how they did this!
Thank you for working with me on this!!
If you had not prompted an explanation of the issue as deeply as you did, I don't think I would have seen that I already knew a solution.