You can select the Always one selected value for a field in an app. The value specifies that one, and only one, value is always selected for a field. You can use this value to specify, for example, that one currency is always selected for a field.
Consider the following when using the Always one selected value:
- You can use the Always one selected value on one or more fields.
- You cannot clear the Always one selected value setting when viewing a sheet. You can, however, clear the setting by editing the sheet in your workspace.
- When you publish an app with the Always one selected value selected, the value is applied to all sheets in the app. The app consumer cannot clear the value.
- When you duplicate an app, the Always one selected value is duplicated with the app.
- When you export an app without data, the Always one selected value is not exported with the app.
- The Always one selected value is not supported for derived fields.
You can use the value with a default bookmark in to highlight specific selections for your app consumer. For an example, see Always one selected value and default bookmark example: Controlling selections to guide app consumers to insights.
For more information about default bookmarks, see Setting a default bookmark to create an app landing page.
Set the Always one selected value
Do the following:
- Open a sheet in an app.
- Click
Edit sheet. - Click Fields.
- Right-click a field, and then click Field settings.
- In the window that opens, select the Always one selected value check box, and then save.
-
Exit sheet edit mode. The value appears as a tab in the top toolbar. Unlike a bookmark, there is no option to clear the selection.
The Always one selected value in the toolbar
The Always one selected value defaults to the first entry in the field. In the example above, the value is applied to Region. Asia is the region that is selected by default. You or your app consumer can change this selection, in this case to a different region.
- To test that the Always one selected value is working properly, close and then reopen the app. The value should be shown in the top toolbar.
To remove the Always one selected value for a field, right-click the field in Edit mode, click Field settings, and deselect the Always one selected value check box.
Always one selected value and default bookmark example: Controlling selections to guide app consumers to insights
In this example, we set Always one selected value for a field. We then specify a default bookmark for the app. By specifying a default bookmark, and enabling Always one selected value, we control what our app consumers see when they open our published app.
-
Here is a sheet in our app before the Always one selected value and a default bookmark are applied. This should be the sheet that you want app consumers to see as a landing page when they open the app.
App in sheet analysis mode
The chart in the app is built using Country as a dimension, and Sum([Total Revenue]) as a measure.
-
To ensure that one, and only one, value is always selected for the Region field, we edit the sheet, click Fields, and then right-click Region.
-
Click Field settings.
-
We then select the Always one selected value checkbox and save.
Turning on the Always one selected value setting
-
When we close Edit mode for the sheet, the Always one selected value value appears as a tab in the top toolbar. The value defaults to the first entry in the field. In this case, the default value is Asia.
App in sheet view with default value selected for Always one selected value field
-
However, we want to show revenue for sub-Saharan Africa when the app is opened. So we select Sub-Saharan Africa from the Region field, and then click Bookmarks to create a new bookmark for Region("Sub-Saharan Africa"). We then right-click the Region("Sub-Saharan Africa") bookmark, and click Set as default bookmark.
Now, when we open the app, or publish the app for an app consumer, the app opens with one value selected, and the default bookmark is shown. The app is opened on the sheet of the bookmark instead of the app overview.
App opened with default bookmark, using the defined selection Sub-Saharan Africa
