Add user.email to dashbord filter

Hi,
as shown in the image below, the dashboard filter allows us to filter on Lastname (which is not unique and has little value as a criterion) or ID (which is unintelligible for humans).
We want to search based on name and email. how do I set this up?

Hi @finn.frotscher
I don't think I understand. Then you need to connect the filter to a different field, if you want it do connect on that field instead.
You cannot search multiple fields in a single filter. There's no "global search", you need to create a filter for each field you want to be searchable.

the filter actually works already on basis of email.
i think the issue is with the autosuggest and the text inside the input field.

@flamber
I want the input to say search by email or name instead of search by firstname or enter an id

also, when I type Into the input finn@cofenster.com i want the autocomplete to find the user with the email finn@cofenster.com. right now it shows no results.

@finn.frotscher I have absolutely no idea of how you've structured your database or how the Data Model looks in Metabase.

Post "Diagnostic Info" from Admin > Troubleshooting.

You would have to provide a lot of data for me to understand how you're connected things.
At a minimum the response from /api/dashboard/123, where 123 is your dashboard ID.

{
"browser-info": {
"language": "en-US",
"platform": "MacIntel",
"userAgent": "Mozilla/5.0 (Macintosh; Intel Mac OS X 10.15; rv:93.0) Gecko/20100101 Firefox/93.0",
"vendor": ""
},
"system-info": {
"file.encoding": "UTF-8",
"java.runtime.name": "OpenJDK Runtime Environment",
"java.runtime.version": "11.0.12+7",
"java.vendor": "Eclipse Foundation",
"java.vendor.url": "https://adoptium.net/",
"java.version": "11.0.12",
"java.vm.name": "OpenJDK 64-Bit Server VM",
"java.vm.version": "11.0.12+7",
"os.name": "Linux",
"os.version": "4.14.219-164.354.amzn2.x86_64",
"user.language": "en",
"user.timezone": "GMT"
},
"metabase-info": {
"databases": [
"bigquery"
],
"hosting-env": "unknown",
"application-database": "postgres",
"application-database-details": {
"database": {
"name": "PostgreSQL",
"version": "11.9"
},
"jdbc-driver": {
"name": "PostgreSQL JDBC Driver",
"version": "42.2.18"
}
},
"run-mode": "prod",
"version": {
"date": "2021-09-21",
"tag": "v1.40.5",
"branch": "release-x.40.x",
"hash": "042a36e"
},
"settings": {
"report-timezone": null
}
}
}

how would i need to structure the database or model to get the result i want?

@finn.frotscher So you are using Metabase Cloud?
It should just work, so I'm not sure why it's not working for you, but since this involves so many spinning parts, then I cannot give you an answer without understanding what the problem is, and I can only understand that by getting a lot of metadata.

the dashboard is located at:
https://cofenster.metabaseapp.com/dashboard/4-customer-usage

calling
https://cofenster.metabaseapp.com/api/dashboard/4-customer-usage
or
https://cofenster.metabaseapp.com/api/4-customer-usage
results in
"API endpoint does not exist."

@finn.frotscher The API only uses the ID, so it's just /api/dashboard/4

{"description":"This dashboards helps the CSM to see how the selected account is using cofenster.","archived":false,"collection_position":1,"ordered_cards":[{"sizeX":4,"series":[],"collection_authority_level":null,"card":{"description":null,"archived":false,"collection_position":null,"table_id":15,"result_metadata":[{"name":"count","display_name":"Count","base_type":"type/Integer","semantic_type":"type/Quantity","field_ref":["aggregation",0],"fingerprint":{"global":{"distinct-count":1,"nil%":0.0},"type":{"type/Number":{"min":1355.0,"q1":1355.0,"q3":1355.0,"max":1355.0,"sd":null,"avg":1355.0}}}}],"database_id":2,"enable_embedding":false,"collection_id":null,"query_type":"query","name":"Number of downloaded videos","query_average_duration":1510,"creator_id":5,"updated_at":"2021-10-14T10:58:36.300514Z","made_public_by_id":null,"embedding_params":null,"cache_ttl":null,"dataset_query":{"type":"query","query":{"source-table":15,"aggregation":[["count"]]},"database":2},"id":11,"display":"scalar","visualization_settings":{},"created_at":"2021-09-28T07:08:12.736217Z","public_uuid":null},"updated_at":"2021-10-13T11:57:40.664381Z","col":11,"id":8,"parameter_mappings":[{"parameter_id":"f026bc51","card_id":11,"target":["dimension",["field",319,{"source-field":452}]]}],"card_id":11,"visualization_settings":{},"dashboard_id":4,"created_at":"2021-09-28T07:08:22.478078Z","sizeY":4,"row":4},{"sizeX":4,"series":[],"collection_authority_level":null,"card":{"description":null,"archived":false,"collection_position":null,"table_id":15,"result_metadata":[{"semantic_type":"type/Category","coercion_strategy":null,"name":"videoFormat","field_ref":["field",386,{"source-field":472}],"effective_type":"type/Text","id":386,"display_name":"Project → Videoformat","fingerprint":{"global":{"distinct-count":2,"nil%":0.0},"type":{"type/Text":{"percent-json":0.0,"percent-url":0.0,"percent-email":0.0,"percent-state":0.0,"average-length":9.187652068126521}}},"base_type":"type/Text"},{"semantic_type":null,"coercion_strategy":null,"unit":"month","name":"timestamp","field_ref":["field",459,{"temporal-unit":"month"}],"effective_type":"type/DateTimeWithLocalTZ","id":459,"display_name":"Timestamp","fingerprint":{"global":{"distinct-count":909,"nil%":0.0},"type":{"type/DateTime":{"earliest":"2021-07-23T07:54:16.035Z","latest":"2021-09-21T08:30:04.312Z"}}},"base_type":"type/DateTimeWithLocalTZ"},{"name":"count","display_name":"Count","base_type":"type/Integer","semantic_type":"type/Quantity","field_ref":["aggregation",0],"fingerprint":{"global":{"distinct-count":8,"nil%":0.0},"type":{"type/Number":{"min":45.0,"q1":87.5,"q3":232.5,"max":402.0,"sd":116.92236435222428,"avg":169.375}}}}],"database_id":2,"enable_embedding":false,"collection_id":8,"query_type":"query","name":"Video Format (Project Downloads)","query_average_duration":1974,"creator_id":5,"updated_at":"2021-10-14T10:58:36.372194Z","made_public_by_id":null,"embedding_params":null,"cache_ttl":null,"dataset_query":{"database":2,"query":{"source-table":15,"aggregation":[["count"]],"breakout":[["field",386,{"source-field":472}],["field",459,{"temporal-unit":"month"}]]},"type":"query"},"id":12,"display":"bar","visualization_settings":{"graph.dimensions":["timestamp","videoFormat"],"graph.metrics":["count"]},"created_at":"2021-09-28T07:46:11.223337Z","public_uuid":null},"updated_at":"2021-10-13T11:57:40.677332Z","col":5,"id":10,"parameter_mappings":[{"parameter_id":"f026bc51","card_id":12,"target":["dimension",["field",319,{"source-field":452}]]}],"card_id":12,"visualization_settings":{},"dashboard_id":4,"created_at":"2021-09-28T07:46:19.085972Z","sizeY":4,"row":8},{"sizeX":4,"series":[],"collection_authority_level":null,"card":{"description":null,"archived":false,"collection_position":null,"table_id":17,"result_metadata":[{"semantic_type":"type/Name","coercion_strategy":null,"name":"name","field_ref":["field",551,{"join-alias":"Dim Story - Story"}],"effective_type":"type/Text","id":551,"display_name":"Dim Story - Story → Name","fingerprint":{"global":{"distinct-count":13,"nil%":0.0},"type":{"type/Text":{"percent-json":0.0,"percent-url":0.0,"percent-email":0.0,"percent-state":0.0,"average-length":18.923076923076923}}},"base_type":"type/Text"},{"name":"count","display_name":"Count","base_type":"type/Integer","semantic_type":"type/Quantity","field_ref":["aggregation",0],"fingerprint":{"global":{"distinct-count":3,"nil%":0.0},"type":{"type/Number":{"min":1.0,"q1":1.0,"q3":3.75,"max":6.0,"sd":2.1908902300206643,"avg":2.4}}}}],"database_id":2,"enable_embedding":false,"collection_id":8,"query_type":"query","name":"Project created by story template","query_average_duration":1977,"creator_id":5,"updated_at":"2021-10-14T10:58:37.130394Z","made_public_by_id":null,"embedding_params":null,"cache_ttl":null,"dataset_query":{"database":2,"query":{"source-table":17,"joins":[{"fields":"all","source-table":10,"condition":["=",["field",530,null],["field",378,{"join-alias":"Dim Project - Project"}]],"alias":"Dim Project - Project"},{"fields":"all","source-table":18,"condition":["=",["field",528,null],["field",545,{"join-alias":"Dim Story - Story"}]],"alias":"Dim Story - Story"}],"filter":["=",["field",319,{"source-field":520}],"miriam.fluegger@zal.aero"],"aggregation":[["count"]],"breakout":[["field",551,{"join-alias":"Dim Story - Story"}]]},"type":"query"},"id":13,"display":"bar","visualization_settings":{"graph.dimensions":["name"],"graph.metrics":["count"]},"created_at":"2021-09-28T07:56:02.324396Z","public_uuid":null},"updated_at":"2021-10-13T11:57:40.682618Z","col":1,"id":11,"parameter_mappings":[{"parameter_id":"f026bc51","card_id":13,"target":["dimension",["field",319,{"source-field":520}]]}],"card_id":13,"visualization_settings":{},"dashboard_id":4,"created_at":"2021-09-28T08:00:15.123711Z","sizeY":4,"row":8},{"sizeX":4,"series":[],"collection_authority_level":null,"card":{"description":null,"archived":false,"collection_position":null,"table_id":15,"result_metadata":[{"semantic_type":"type/Category","coercion_strategy":null,"name":"numer_of_shots","field_ref":["field",464,{"binning":{"strategy":"num-bins","min-value":0.0,"max-value":30.0,"num-bins":8,"bin-width":5}}],"effective_type":"type/Integer","id":464,"display_name":"Numer Of Shots","fingerprint":{"global":{"distinct-count":20,"nil%":0.6864686468646864},"type":{"type/Number":{"min":1.0,"q1":1.6613565169931206,"q3":4.926268478688157,"max":29.0,"sd":3.8660292752773753,"avg":4.031578947368421}}},"base_type":"type/Float"},{"semantic_type":"type/CreationTimestamp","coercion_strategy":null,"unit":"month","name":"createdAt","field_ref":["field",368,{"source-field":472,"temporal-unit":"month"}],"effective_type":"type/DateTimeWithLocalTZ","id":368,"display_name":"Project → Createdat","fingerprint":{"global":{"distinct-count":6575,"nil%":0.0},"type":{"type/DateTime":{"earliest":"2020-04-01T03:37:18.829Z","latest":"2021-09-07T14:49:30.808Z"}}},"base_type":"type/DateTimeWithLocalTZ"},{"name":"count","display_name":"Count","base_type":"type/Integer","semantic_type":"type/Quantity","field_ref":["aggregation",0],"fingerprint":{"global":{"distinct-count":14,"nil%":0.0},"type":{"type/Number":{"min":1.0,"q1":1.4722222222222223,"q3":13.5,"max":479.0,"sd":96.81534012765546,"avg":38.714285714285715}}}}],"database_id":2,"enable_embedding":false,"collection_id":8,"query_type":"query","name":"Number of Shots in downloaded video","query_average_duration":1676,"creator_id":5,"updated_at":"2021-10-14T10:58:36.68552Z","made_public_by_id":null,"embedding_params":null,"cache_ttl":null,"dataset_query":{"database":2,"query":{"source-table":15,"aggregation":[["count"]],"breakout":[["field",464,{"binning":{"strategy":"default"}}],["field",368,{"source-field":472,"temporal-unit":"month"}]]},"type":"query"},"id":15,"display":"line","visualization_settings":{"graph.dimensions":["createdat","numer_of_shots"],"graph.metrics":["count"]},"created_at":"2021-09-28T08:52:06.729218Z","public_uuid":null},"updated_at":"2021-10-13T11:57:40.689072Z","col":13,"id":13,"parameter_mappings":[{"parameter_id":"f026bc51","card_id":15,"target":["dimension",["field",319,{"source-field":452}]]}],"card_id":15,"visualization_settings":{},"dashboard_id":4,"created_at":"2021-09-28T08:52:15.786988Z","sizeY":4,"row":8},{"sizeX":4,"series":[],"collection_authority_level":null,"card":{"description":null,"archived":false,"collection_position":null,"table_id":11,"result_metadata":[{"name":"avg","display_name":"Average of Count","base_type":"type/Float","semantic_type":"type/Quantity","field_ref":["aggregation",0],"fingerprint":{"global":{"distinct-count":1,"nil%":0.0},"type":{"type/Number":{"min":2.9742388758782203,"q1":2.9742388758782203,"q3":2.9742388758782203,"max":2.9742388758782203,"sd":null,"avg":2.9742388758782203}}}}],"database_id":2,"enable_embedding":false,"collection_id":8,"query_type":"query","name":"Avg. render / video","query_average_duration":1812,"creator_id":1,"updated_at":"2021-10-14T10:58:36.529202Z","made_public_by_id":null,"embedding_params":null,"cache_ttl":null,"dataset_query":{"database":2,"query":{"source-query":{"source-table":11,"aggregation":[["count"]],"breakout":[["field",332,null],["field",319,{"join-alias":"Dim User - User"}]],"joins":[{"fields":"all","source-table":9,"condition":["=",["field",338,null],["field",359,{"join-alias":"Dim User - User"}]],"alias":"Dim User - User"}]},"aggregation":[["avg",["field","count",{"base-type":"type/Integer"}]]]},"type":"query"},"id":19,"display":"scalar","visualization_settings":{"table.pivot":false,"table.cell_column":"avg"},"created_at":"2021-09-29T09:59:57.875331Z","public_uuid":null},"updated_at":"2021-10-13T11:57:40.700303Z","col":9,"id":17,"parameter_mappings":[{"parameter_id":"f026bc51","card_id":19,"target":["dimension",["field","email",{"base-type":"type/Text"}]]}],"card_id":19,"visualization_settings":{},"dashboard_id":4,"created_at":"2021-09-29T10:00:20.677402Z","sizeY":4,"row":12},{"sizeX":4,"series":[],"collection_authority_level":null,"card":{"description":null,"archived":false,"collection_position":null,"table_id":15,"result_metadata":[{"name":"avg","display_name":"Average of Scene Count","base_type":"type/Float","semantic_type":"type/Quantity","field_ref":["aggregation",0],"fingerprint":{"global":{"distinct-count":1,"nil%":0.0},"type":{"type/Number":{"min":5.285714285714285,"q1":5.285714285714285,"q3":5.285714285714285,"max":5.285714285714285,"sd":null,"avg":5.285714285714285}}}}],"database_id":2,"enable_embedding":false,"collection_id":8,"query_type":"query","name":"Avg. scenes / finalized video","query_average_duration":1721,"creator_id":5,"updated_at":"2021-10-14T10:58:36.701398Z","made_public_by_id":null,"embedding_params":null,"cache_ttl":null,"dataset_query":{"database":2,"query":{"source-table":15,"aggregation":[["avg",["field",477,null]]]},"type":"query"},"id":20,"display":"scalar","visualization_settings":{},"created_at":"2021-09-30T11:54:40.508463Z","public_uuid":null},"updated_at":"2021-10-13T11:57:40.706825Z","col":5,"id":18,"parameter_mappings":[{"parameter_id":"f026bc51","card_id":20,"target":["dimension",["field",319,{"source-field":452}]]}],"card_id":20,"visualization_settings":{},"dashboard_id":4,"created_at":"2021-09-30T11:55:01.52873Z","sizeY":4,"row":12},{"sizeX":4,"series":[],"collection_authority_level":null,"card":{"description":null,"archived":false,"collection_position":null,"table_id":19,"result_metadata":[{"semantic_type":null,"coercion_strategy":null,"unit":"week","name":"timestamp","field_ref":["field",787,{"temporal-unit":"week"}],"effective_type":"type/DateTimeWithLocalTZ","id":787,"display_name":"Timestamp","fingerprint":{"global":{"distinct-count":9999,"nil%":0.0},"type":{"type/DateTime":{"earliest":"2021-04-05T19:08:24.003Z","latest":"2021-10-12T17:26:33.904Z"}}},"base_type":"type/DateTimeWithLocalTZ"},{"semantic_type":"type/Category","coercion_strategy":null,"name":"event","field_ref":["field",583,null],"effective_type":"type/Text","id":583,"display_name":"Event","fingerprint":{"global":{"distinct-count":3,"nil%":0.0},"type":{"type/Text":{"percent-json":0.0,"percent-url":0.0,"percent-email":0.0,"percent-state":0.0,"average-length":14.1782}}},"base_type":"type/Text"},{"name":"count","display_name":"Count","base_type":"type/Integer","semantic_type":"type/Quantity","field_ref":["aggregation",0],"fingerprint":{"global":{"distinct-count":48,"nil%":0.0},"type":{"type/Number":{"min":4.0,"q1":46.25,"q3":176.75,"max":411.0,"sd":95.11084554968727,"avg":121.3529411764706}}}}],"database_id":2,"enable_embedding":false,"collection_id":8,"query_type":"query","name":"Overall user activity last 3 months","query_average_duration":1661,"creator_id":5,"updated_at":"2021-10-14T10:58:36.254523Z","made_public_by_id":null,"embedding_params":null,"cache_ttl":null,"dataset_query":{"type":"query","query":{"source-table":19,"breakout":[["field",787,{"temporal-unit":"week"}],["field",583,null]],"aggregation":[["count"]],"filter":["time-interval",["field",787,null],-12,"week",{"include-current":true}]},"database":2},"id":22,"display":"area","visualization_settings":{"graph.dimensions":["timestamp","event"],"graph.metrics":["count"]},"created_at":"2021-10-12T06:01:57.442474Z","public_uuid":null},"updated_at":"2021-10-13T11:57:40.736173Z","col":3,"id":20,"parameter_mappings":[{"parameter_id":"f026bc51","card_id":22,"target":["dimension",["field",319,{"source-field":586}]]}],"card_id":22,"visualization_settings":{},"dashboard_id":4,"created_at":"2021-10-12T06:02:58.194385Z","sizeY":4,"row":4},{"sizeX":4,"series":[],"collection_authority_level":null,"card":{"description":null,"archived":false,"collection_position":null,"table_id":9,"result_metadata":[{"semantic_type":"type/CreationTimestamp","coercion_strategy":null,"unit":"month","name":"createdAt","field_ref":["field",368,{"temporal-unit":"month","join-alias":"Dim Project"}],"effective_type":"type/DateTimeWithLocalTZ","id":368,"display_name":"Dim Project → Createdat","fingerprint":{"global":{"distinct-count":6575,"nil%":0.0},"type":{"type/DateTime":{"earliest":"2020-04-01T03:37:18.829Z","latest":"2021-09-07T14:49:30.808Z"}}},"base_type":"type/DateTimeWithLocalTZ"},{"name":"count","display_name":"Count","base_type":"type/Integer","semantic_type":"type/Quantity","field_ref":["aggregation",0],"fingerprint":{"global":{"distinct-count":20,"nil%":0.0},"type":{"type/Number":{"min":249.0,"q1":810.5,"q3":5172.0,"max":7604.0,"sd":2490.164883042254,"avg":3115.25}}}},{"name":"count_2","display_name":"Count","base_type":"type/Integer","semantic_type":"type/Quantity","field_ref":["aggregation",1],"fingerprint":{"global":{"distinct-count":20,"nil%":0.0},"type":{"type/Number":{"min":80.0,"q1":211.0,"q3":563.0,"max":728.0,"sd":202.32350333068075,"avg":380.2}}}}],"database_id":2,"enable_embedding":false,"collection_id":8,"query_type":"query","name":"Project created & cumulated","query_average_duration":1944,"creator_id":5,"updated_at":"2021-10-14T10:58:35.503243Z","made_public_by_id":null,"embedding_params":null,"cache_ttl":null,"dataset_query":{"type":"query","query":{"source-table":9,"joins":[{"fields":"all","source-table":10,"condition":["=",["field",359,null],["field",377,{"join-alias":"Dim Project"}]],"alias":"Dim Project"}],"aggregation":[["cum-count"],["count"]],"breakout":[["field",368,{"temporal-unit":"month","join-alias":"Dim Project"}]]},"database":2},"id":23,"display":"line","visualization_settings":{"graph.show_goal":false,"graph.show_trendline":true,"graph.show_values":true,"graph.x_axis.axis_enabled":"compact","stackable.stack_display":"area","graph.label_value_frequency":"fit","graph.metrics":["count","count_2"],"graph.y_axis.axis_enabled":false,"graph.label_value_formatting":"full","column_settings":{"[\"name\",\"count\"]":{"prefix":""}},"series_settings":{"count":{"title":"Sum","display":"line","line.interpolate":"linear","line.marker_enabled":true},"count_2":{"display":"bar"}},"graph.x_axis.scale":"timeseries","graph.dimensions":["createdAt"],"stackable.stack_type":null},"created_at":"2021-10-12T06:03:54.46181Z","public_uuid":null},"updated_at":"2021-10-13T11:57:40.741739Z","col":7,"id":21,"parameter_mappings":[{"parameter_id":"f026bc51","card_id":23,"target":["dimension",["field",319,null]]}],"card_id":23,"visualization_settings":{},"dashboard_id":4,"created_at":"2021-10-12T06:04:35.45726Z","sizeY":4,"row":4},{"sizeX":4,"series":[],"collection_authority_level":null,"card":{"description":null,"archived":false,"collection_position":null,"table_id":15,"result_metadata":[{"semantic_type":"type/Category","coercion_strategy":null,"name":"with_music","field_ref":["field",469,null],"effective_type":"type/Boolean","id":469,"display_name":"With Music","fingerprint":{"global":{"distinct-count":2,"nil%":0.0}},"base_type":"type/Boolean"},{"semantic_type":"type/CreationTimestamp","coercion_strategy":null,"unit":"month","name":"createdAt","field_ref":["field",368,{"source-field":472,"temporal-unit":"month"}],"effective_type":"type/DateTimeWithLocalTZ","id":368,"display_name":"Project → Createdat","fingerprint":{"global":{"distinct-count":6575,"nil%":0.0},"type":{"type/DateTime":{"earliest":"2020-04-01T03:37:18.829Z","latest":"2021-09-07T14:49:30.808Z"}}},"base_type":"type/DateTimeWithLocalTZ"},{"name":"count","display_name":"Count","base_type":"type/Integer","semantic_type":"type/Quantity","field_ref":["aggregation",0],"fingerprint":{"global":{"distinct-count":16,"nil%":0.0},"type":{"type/Number":{"min":1.0,"q1":2.0560797112240508,"q3":102.75,"max":265.0,"sd":84.58449946300513,"avg":58.91304347826087}}}}],"database_id":2,"enable_embedding":false,"collection_id":8,"query_type":"query","name":"Downloaded Projects with Music (=true)","query_average_duration":2736,"creator_id":5,"updated_at":"2021-10-14T10:58:36.591075Z","made_public_by_id":null,"embedding_params":null,"cache_ttl":null,"dataset_query":{"database":2,"query":{"source-table":15,"aggregation":[["count"]],"breakout":[["field",469,null],["field",368,{"source-field":472,"temporal-unit":"month"}]]},"type":"query"},"id":24,"display":"area","visualization_settings":{"graph.dimensions":["createdAt","with_music"],"graph.metrics":["count"]},"created_at":"2021-10-12T06:19:23.059116Z","public_uuid":null},"updated_at":"2021-10-13T11:57:40.747207Z","col":9,"id":22,"parameter_mappings":[{"parameter_id":"f026bc51","card_id":24,"target":["dimension",["field",319,{"source-field":452}]]}],"card_id":24,"visualization_settings":{},"dashboard_id":4,"created_at":"2021-10-12T06:20:23.243313Z","sizeY":4,"row":8},{"sizeX":4,"series":[],"collection_authority_level":null,"card":{"description":null,"archived":false,"collection_position":null,"table_id":19,"result_metadata":[{"semantic_type":null,"coercion_strategy":null,"unit":"default","name":"timestamp","field_ref":["field",787,{"temporal-unit":"default"}],"effective_type":"type/DateTimeWithLocalTZ","id":787,"display_name":"Timestamp","fingerprint":{"global":{"distinct-count":9999,"nil%":0.0},"type":{"type/DateTime":{"earliest":"2021-04-05T19:08:24.003Z","latest":"2021-10-12T17:26:33.904Z"}}},"base_type":"type/DateTimeWithLocalTZ"},{"semantic_type":"type/Category","coercion_strategy":null,"name":"event","field_ref":["field",583,null],"effective_type":"type/Text","id":583,"display_name":"Event","fingerprint":{"global":{"distinct-count":3,"nil%":0.0},"type":{"type/Text":{"percent-json":0.0,"percent-url":0.0,"percent-email":0.0,"percent-state":0.0,"average-length":14.1782}}},"base_type":"type/Text"},{"semantic_type":"type/Name","coercion_strategy":null,"name":"name","field_ref":["field",385,{"source-field":588}],"effective_type":"type/Text","id":385,"display_name":"Entity Project → Name","fingerprint":{"global":{"distinct-count":5025,"nil%":0.0},"type":{"type/Text":{"percent-json":0.0,"percent-url":0.0,"percent-email":0.0,"percent-state":4.562043795620438E-4,"average-length":15.987530413625304}}},"base_type":"type/Text"}],"database_id":2,"enable_embedding":false,"collection_id":8,"query_type":"query","name":"Last Activity","query_average_duration":2157,"creator_id":1,"updated_at":"2021-10-14T10:58:37.285946Z","made_public_by_id":null,"embedding_params":null,"cache_ttl":null,"dataset_query":{"database":2,"query":{"source-table":19,"joins":[{"fields":"none","source-table":9,"condition":["=",["field",586,null],["field",359,{"join-alias":"Dim User - User"}]],"alias":"Dim User - User"},{"fields":"none","source-table":10,"condition":["=",["field",588,null],["field",378,{"join-alias":"Dim Project - Entity Project"}]],"alias":"Dim Project - Entity Project"}],"order-by":[["desc",["field",787,null]]],"limit":3,"fields":[["field",787,{"temporal-unit":"default"}],["field",583,null],["field",385,{"source-field":588}]]},"type":"query"},"id":25,"display":"table","visualization_settings":{"table.pivot_column":"user_id","table.cell_column":"projects","table.columns":[{"name":"timestamp","fieldRef":["field",787,{"temporal-unit":"default"}],"enabled":true},{"name":"event","fieldRef":["field",583,null],"enabled":true},{"name":"entity_project_id","fieldRef":["field",588,null],"enabled":false},{"name":"name","fieldRef":["field",385,{"source-field":588}],"enabled":true}]},"created_at":"2021-10-13T08:32:41.885782Z","public_uuid":null},"updated_at":"2021-10-13T11:57:40.752971Z","col":3,"id":33,"parameter_mappings":[{"parameter_id":"f026bc51","card_id":25,"target":["dimension",["field",319,{"join-alias":"Dim User - User"}]]}],"card_id":25,"visualization_settings":{},"dashboard_id":4,"created_at":"2021-10-13T08:32:55.118283Z","sizeY":4,"row":0},{"sizeX":4,"series":[],"collection_authority_level":null,"card":{"description":null,"archived":false,"collection_position":null,"table_id":19,"result_metadata":[{"semantic_type":"type/Category","coercion_strategy":null,"name":"event","field_ref":["field",583,null],"effective_type":"type/Text","id":583,"display_name":"Event","fingerprint":{"global":{"distinct-count":3,"nil%":0.0},"type":{"type/Text":{"percent-json":0.0,"percent-url":0.0,"percent-email":0.0,"percent-state":0.0,"average-length":14.1782}}},"base_type":"type/Text"},{"name":"count","display_name":"Count","base_type":"type/Integer","semantic_type":"type/Quantity","field_ref":["aggregation",0],"fingerprint":{"global":{"distinct-count":6,"nil%":0.0},"type":{"type/Number":{"min":30.0,"q1":80.0,"q3":620.0,"max":1274.0,"sd":476.044710785307,"avg":439.1666666666667}}}}],"database_id":2,"enable_embedding":false,"collection_id":8,"query_type":"query","name":"Account activities last 30 days","query_average_duration":1541,"creator_id":5,"updated_at":"2021-10-14T10:58:36.277787Z","made_public_by_id":null,"embedding_params":null,"cache_ttl":null,"dataset_query":{"database":2,"query":{"source-table":19,"aggregation":[["count"]],"breakout":[["field",583,null]],"filter":["time-interval",["field",787,null],-30,"day",{"include-current":true}]},"type":"query"},"id":26,"display":"bar","visualization_settings":{"scalar.switch_positive_negative":false,"graph.dimensions":["event"],"graph.metrics":["count"]},"created_at":"2021-10-13T09:04:05.051932Z","public_uuid":null},"updated_at":"2021-10-13T11:57:40.758735Z","col":11,"id":34,"parameter_mappings":[{"parameter_id":"f026bc51","card_id":26,"target":["dimension",["field",319,{"source-field":586}]]}],"card_id":26,"visualization_settings":{},"dashboard_id":4,"created_at":"2021-10-13T09:04:40.717651Z","sizeY":4,"row":0},{"sizeX":4,"series":[],"collection_authority_level":null,"card":{"description":null,"archived":false,"collection_position":null,"table_id":19,"result_metadata":[{"semantic_type":null,"coercion_strategy":null,"unit":"day","name":"timestamp","field_ref":["field",787,{"temporal-unit":"day"}],"effective_type":"type/DateTimeWithLocalTZ","id":787,"display_name":"Timestamp","fingerprint":{"global":{"distinct-count":9999,"nil%":0.0},"type":{"type/DateTime":{"earliest":"2021-04-05T19:08:24.003Z","latest":"2021-10-12T17:26:33.904Z"}}},"base_type":"type/DateTimeWithLocalTZ"},{"name":"count","display_name":"Count","base_type":"type/Integer","semantic_type":"type/Quantity","field_ref":["aggregation",0],"fingerprint":{"global":{"distinct-count":27,"nil%":0.0},"type":{"type/Number":{"min":1.0,"q1":69.0,"q3":138.5,"max":204.0,"sd":55.51799126857306,"avg":94.10714285714286}}}}],"database_id":2,"enable_embedding":false,"collection_id":8,"query_type":"query","name":"User activity last 30 days","query_average_duration":2220,"creator_id":5,"updated_at":"2021-10-14T10:58:36.276678Z","made_public_by_id":null,"embedding_params":null,"cache_ttl":null,"dataset_query":{"database":2,"query":{"source-table":19,"aggregation":[["count"]],"filter":["time-interval",["field",787,null],-30,"day"],"breakout":[["field",787,{"temporal-unit":"day"}]]},"type":"query"},"id":27,"display":"area","visualization_settings":{"scalar.switch_positive_negative":false,"graph.dimensions":["timestamp"],"graph.metrics":["count"]},"created_at":"2021-10-13T09:09:23.196899Z","public_uuid":null},"updated_at":"2021-10-13T11:57:40.764463Z","col":7,"id":35,"parameter_mappings":[{"parameter_id":"f026bc51","card_id":27,"target":["dimension",["field",319,{"source-field":586}]]}],"card_id":27,"visualization_settings":{},"dashboard_id":4,"created_at":"2021-10-13T09:10:47.758078Z","sizeY":4,"row":0}],"param_values":null,"can_write":true,"enable_embedding":false,"collection_id":8,"show_in_getting_started":false,"name":"Customer Usage","caveats":null,"collection_authority_level":null,"creator_id":5,"updated_at":"2021-10-13T11:57:41.380142Z","made_public_by_id":null,"embedding_params":null,"id":4,"position":null,"param_fields":{"319":{"id":319,"table_id":9,"display_name":"Email","base_type":"type/Text","semantic_type":"type/PK","has_field_values":"search","name_field":{"id":314,"table_id":9,"display_name":"Name","base_type":"type/Text","semantic_type":"type/Name","has_field_values":"search"},"dimensions":[]}},"last-edit-info":{"id":1,"email":"finn@cofenster.com","first_name":"Finn","last_name":"Frotscher","timestamp":"2021-10-13T11:57:41.407614Z"},"parameters":[{"name":"Customer","slug":"customer","id":"f026bc51","type":"id","sectionId":"id"}],"created_at":"2021-09-27T14:40:20.911935Z","public_uuid":null,"points_of_interest":null}

@finn.frotscher Okay, so you have multiple cards (questions on the dashboard), which is connected to this filter, but they are not referencing the same field, so that is what is causing the problem.

Try to disconnect all the cards from the filter, and connect each card one-by-one, while saving in-between, so you check which cards are causing problematic behavior.

Nothing. as long as i have one chart (any from the dashboard) I get this choice.

@finn.frotscher Okay, but if you only want the filter on the "Email" field, then you should select that as the connection. Currently it looks like you've selected an ID field, which is using remapping to firstname field.

It's quite difficult to help, since I don't know your database structure.
Try creating a new dashboard with just a single card and one filter. It makes a little easier to simplify everything.

Hopefully the documentation can help you a bit:
https://www.metabase.com/docs/latest/administration-guide/03-metadata-editing.html