Hello~
Within my workbook, I have a date that I would like to preset as today.
I used the calculation Start.Date=TODAY() and set this condition to TRUE.
The first time I used this, it seemed to work super well, so I applied this to all of the workbooks with a start date.
Now, I am going back to these workbooks and finding that the conditions did not hold up. Instead of displaying today, they display the date that the workbook was set to the abovementioned condition. AND the condition filter is automatically reset to FALSE.
Is there a way I can make this work? I just want the start date to always display <TODAY()>'s value.
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!
