Customise the field that a option list is applied to

Hi,

I have a data set containing containing objects in the following format:

{
  "id": 123,
  "displayName": "foo"
}

I would like to use this to populate an option list. It is important that the user only sees the displayName in the option lists but when a value is selected the filter value is the id field.

Furthermore I'd need to use this filter on data with the following structure:

{
  "metadata": {
    "relationId": 123
  },
  "other fields": "bar"
}

Where the filter should be applied to the nested property "relationId". Is this possible in kibana dashboards and if so, how?

Unfortunately the controls UI does not work that way. If you could formulate your feature request in our GitHub issue the team can evaluate how feasible it is to accept it.

But I'm not sure if this is something too specific. The options list widget will look on a field and offer to the dashboard consumer a list of terms but you want to look for combinations of two fields and only show one of them and filter by the other right?

Yes, I would like to display one value, filter by another value AND also configure on which field the value filter is applied.