I will suggest to use a 2nd parameter to control whether use default date as today or use a customized date from the pick up parameter as shown below
I attached the workbook for your reference.
Hope this helps
Sample - Error Codes_v10.5.twbx 12.4 KB
Thanks, Zhouyi, for your response! I like your suggestion for the 2nd parameter, however, your calculation assumes that the latest release was within the last week...
The problem with that is that there is not a defined interval between each release. Sometimes, the last release was 2 weeks ago and sometimes it was 4 weeks ago. You have to use the dates in the 1st parameter to compare to today's date.
While your attached workbook provides the same results in the viz, given the sample data I included, the data that comprises the chart is actually different. The correct data in the chart should include rows with dates between 7/16/2018 and 7/23/2018 (1 week period after the release date). But your chart with Parameter 2 = Default actually includes rows with dates between 7/19/2018 and 7/26/2018.
CORRECT: ERR-01 data with Parameter 2 = Custom and Release = July Release.
INCORRECT: ERR-01 data with Parameter 2 = Default.
Do you have another suggestion for how to correct the calculation in Parameter 2 so that it gives the MAX Release date that is less than today's date?