Looker Filters in dashbaord

[zameerbia]

I have these three fields in my view ( department_id, department_name and a calculated field departmetn_display that is a concatenation of both id and name)

I want to create a department filter in dashbaord that will display the filter values as a single select dropdown filter displaying values from department_display field but the Where condition generated should be based on the department_id field

View LookML Snippet

dimension: department_id {
type: number
sql: ${TABLE}.department_id ;;
}

dimension: department_name {
type: string
sql: ${TABLE}.department_name ;;

}

#Concatenate Department ID and Department Name
dimension: department_display {
type: string
sql: ${department_id} || ' - ' || ${department_name} ;;
}