Hi, is it possible to count comma separated values? for example I have this query
| id | col1 |
|---|---|
| 1 | val1, val3 |
| 2 | val3 |
| 3 | val2,val3 |
I want to have this result
| col1 | count(col1) |
|---|---|
| val1 | 1 |
| val2 | 1 |
| val3 | 3 |
Also which SQL syntax should I reference when using redash?
This site is in read only mode. Please continue to browse, but replying, likes,
and other actions are disabled for now.