Select from a table by filter

Get Help
1

Hi,
I would like to do something like this

image
image694×137 6.13 KB

in order to have a generic question to analise any column of any table.
I'm doing a Dashboard to measure data Quality it would be interesting to have 1 dashboard for everything. Is that possible? This example I wrote doesn't work... any shortcut?

thanks
Anna

2

You could use a table valued function if your database supports them.

3

What? I don't understand. What should I investigate for?
thanks!

4

Most 'proper' databases support the notion of a function that returns a table. PostgreSQL - Function Returning A Table - GeeksforGeeks
You could pass the column and table names to a function. It would return the data. You'd need to alias the returned columns so you wouldn't confuse metabase.

I've not tested this but no reason to believe it won't work.

5

sounds great! I look it for, thanks!