Let’s say you have created a Dropdown to filter your charts by Activity Id. However, you want to select the Activity Id’s associated Activity Name from the dropdown instead.
To create a Dropdown with a key-value pair, simply open your Dropdown for editing and drag a second column to the Dimensions section.
The first column’s values are used to filter charts, and the second column will be the display values.
To display Activity Name values in the dropdown, and filter by their associated Activity Id, this is what our preview looks like:
When setting key-value dropdown default values or report values, use the key (first column), not the value (second column).
For more information see our Dropdown dashboard variable documentation.