Autosuggestions help you define the picklist values from another dataset. It will also allow you to specify key/value pairs where a user legible label is shown to the user but an id is passed into the underlying query when selected.
Usage:
Step 1: Select the Filter icon from the top right corner of the dashboard and click on the edit icon of the dashboard filter you want to configure for the autosuggestions.
Step 2: Select the filter condition and filter control.
Step 3: Toggle on the autosuggestion; choose the dataset from which you would like to pick the auto-suggested values or labels, or both.
Note: The auto-suggestion icon is available only on edit modes. If the dashboard, for example, is shared via URL, the icon will not be shown for dataset autosuggestions. In view-only modes, the suggestions are shown based on the dataset associated with the auto-suggestions, (if configured) or will default to the sampling method.
Step 4: Select the auto-suggested values or labels or both (from the dropdown list) you want to fetch from another dataset through filter picklist and click on the Save.
In the above screenshot, id key will be sent to the Query for filtering, and customer values are shown for the filter picklist.
If value and Label are not specified:
-
If the other dataset contains a column with the same name as the column to be filtered, the values of that column are returned.
-
If the other dataset does not contain a column with the same name as the column to be filtered, the values of the first column are returned.
Note: If the label is not specified, only the value will be shown in the picklist*
Step 5: Pick the value from the picklist, click on Apply, for the dashboard to be filtered accordingly.