Combining three attributes that have overlap


In our data, users' languages are stored in three fields: UI language, preferred language and spoken language.

I am trying to write a question (or SQL query) that calculates all Spanish speakers from UI, Spanish speakers from preferred language and Spanish speakers with no duplicates.

Any tips on how to do this?

Hi @Sarah_McRae
It's difficult to understand your data, but it sounds like something you would do in SQL. You can likely find better help in a forum specific to your database type or on since it's not specific to Metabase.

Thanks @flamber, I'll try Stackoverflow.