How do I count occurrences in an array column?

Have you tried a rollup?

Or are you trying to get something like 2,1,1 out of the array?