Tag Field Analysis

Get Help
1

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?

2

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