How to select a value where there's no data and add it to a bookmark?

[johnpaul]

I have a text object which totals a value based on what a user selects that is added to a bookmark. This is done using standard set analysis.

The issue which I have is that users would like to select a value and add it to a bookmark, but there are no values in the database that meet that criteria at the time the bookmark is defined.

Above is the example which I have.

i would like to select all open tickets, which were entered today and are set to Priority 1.

The set analysis which I use for the text object looks like this:

=Count({BM109} Distinct Ticket_Number)

As this is an operational dashboard, open emergency tickets may exist only for a short period of time and may or may not be available when the user is configuring the bookmark.

One option I thought of is to have an additional part of the script which adds all possible values into the data, but this could get quite complex.

I also thought about putting the listbox into AND mode, but that's hard to do for all fields and won't always work.

Using Advanced Search is as hard for the users as is teaching them set analysis, so I don't think that will work OK.