Tag Field Analysis

I am using Postgres and have a simple text type with a comma-separated list inside as the value. For example “red, blue, yellow”.

Is Metabase able to perform analysis on this type of field? Because I can’t seem to get a working solution.

Currently, the table values generated by Metabase come up as, for example:
red, blue, yellow 1
red 1

Rather than:
red 2
blue 1
yellow 1

And if I search “red” it will find ‘red’ but not ‘red, blue, yellow’.

Is this possible in Metabase?

You need to do something on the database side.
Your red,blue,yellow should be split into 3 records. Not a big deal in MS SQL, no idea about Postgres.

1 Like