Hey markpevey! Thanks for posting. The good news: this is fully resolved in Viya 4. Also good news: there is a workaround for VA 7.5/8.x
Back in early versions of Visual Analytics that did not have the ability to select the max value for drop-down lists, I would use a parameter trick with object filters to return the most recent data using drop-down menus when they are cleared. To do this, you'll need to add an indicator for the most recent month in your data. For example:
Date
flag_max_date
OCT2021
0
NOV2021
0
DEC2021
0
JAN2022
1
What we want to do is make sure that it only shows the most recent month if both values are not selected. To do this:
Uncheck the "Required" option for both drop-down lists
Add the following filter to your crosstab:
if(missing('Fiscal Year'p) OR missing('Month'p) ) return 'flag_max_date'n = 1
else 1=1
This filter is saying "If any of the required drop-down lists are missing, only show the most recent data. Otherwise, do not filter anything." "else 1=1" is a trick to get around the required "else" statement so that it does not do anything. Think of this as dynamically enabling the object filter. When all of the right controls are selected, the object filter no longer does anything and the page controls will filter the object. Note that this may result in a missing data error while the user initially selects values, but that will immediately be resolved once they select both a year and a month.
Here is an example of this for a forecasting report that shows historical forecasts. Users can select between forecasts using the drop-down menu. When they clear it, the most recent forecast is always shown.
If you'd like to know more about this trick, check out pages 13-17 of Mastering Parameters in Visual Analytics where it's explained in detail.
... View more