I have a multibox that always has a single value selected for my [AsAt] field. The values are as follows:
2013/14-P13 Most Recent Load as at 2014-03-09 20:12
2013/14-P12 As at 2014-03-01 20:10
2013/14-P11 As at 2014-02-01 20:02
2013/14-P10 As at 2014-01-04 20:11
2013/14-P09 As at 2013-12-07 20:18
2013/14-P08 As at 2013-11-09 19:59
2013/14-P07 As at 2013-10-12 18:55
2013/14-P06 As at 2013-09-14 20:04
2013/14-P05 As at 2013-08-17 16:40
2013/14-P04 As at 2013-07-20 20:09
2013/14-P03 As at 2013-06-08 19:58
Within my multi box, I have sort options set to Numeric Value: Descending and Text: Z -> A. This sorts the values appropriately but when opening the dashboard, 2013/14-P03 is always selected. I would like the most recent period, 2013/14-P13 to be selected by default.
I should note my load script pulls AsAt from a QVD file. Both my QVD script and my dashboard script have Document Properties sorting set to the same as the multibox. The data is refreshed nightly.