Within the dashboards you can create and manage custom filters
Filters opens the Filter menu.
![notion image](https://www.notion.so/image/https%3A%2F%2Fs3-us-west-2.amazonaws.com%2Fsecure.notion-static.com%2Fdb5ef1f9-8a28-4b2c-8185-3a6eafb50d4c%2Fstep-0.png?table=block&id=1050119a-20f0-4ed2-8882-170f1d2deb99&cache=v2)
Click + to create a new Filter
![notion image](https://www.notion.so/image/https%3A%2F%2Fs3-us-west-2.amazonaws.com%2Fsecure.notion-static.com%2F70088c35-bcc3-4af6-a6dc-10904bafb2cb%2Fstep-1.png?table=block&id=fe75b851-d551-4f32-aa79-6a4661123087&cache=v2)
The Edit Filter modal opens
Create the Filter. The Filter Name is used to identify the Filter within the query. Add the values and Save.
![notion image](https://www.notion.so/image/https%3A%2F%2Fs3-us-west-2.amazonaws.com%2Fsecure.notion-static.com%2Fa9361ca9-4832-4643-80a0-f220c19237b4%2Fstep-2.png?table=block&id=8dba3a72-c9dd-4493-aa32-546be6732cbf&cache=v2)
The names are used to identify the value from the dashboard interface.
![notion image](https://www.notion.so/image/https%3A%2F%2Fs3-us-west-2.amazonaws.com%2Fsecure.notion-static.com%2Ff8bbf5c2-fbba-4773-87d5-6658f0a4fb28%2Fstep-3.png?table=block&id=561d4aee-4697-4197-8908-dbece1324218&cache=v2)
When writing the query in SQL, you would use User against the column you want to filter. MySQL example:
select * from payments where [customer_id=User]
This query would generate the following when John A. is selected:
select * from payments where customer_id in (1241)
When choosing multiple custom filters
![notion image](https://www.notion.so/image/https%3A%2F%2Fs3-us-west-2.amazonaws.com%2Fsecure.notion-static.com%2Fb38a9dca-db33-422a-b4e6-686c70629387%2Fstep-4.png?table=block&id=3ed2c071-4ea1-469c-8a41-45ec8c947107&cache=v2)
The generated query would be:
select * from payments where customer_id in (1241, 9321)
Using Mongo driver, would be a query like:
{ "find": "payments", "filter": { "customer_id": "[User]" } }
This would generate a query like:
{ "count": "payments", "query": { "customer_id": { "$in": [ 1241, 9321 ] } } }