Filter should have display column and value column

Feature Requests
1

So, if in dropdown filter I have added a native question and i want to display the names but use the userId for that name in the query that will be super helpful
EG: -
userId

UserId userName
001 Clary
002 Alex

So in dashboard when i click userName filter and chose Alex , in the query UserId ==002 should be passed!

Thanks!

2

You CAN do this if you make a field filter of an ID column that has a metadata relationship (if they are in the same table) or a foreign key relationship (if they are in different tables) to a column with the name. Both the name and the ID number will appear in the dropdown, and you can search by both.