simple frequency distribution in MicroStrategy Dashboard?

Question

this should be an easy question but I cannot solve it...

I have a simple metric, let's say it is called "a", with entries like

a = (B,A,A,B,C,A,A)

Now what I would like to gain is the frequency of each entry, thus

A: 4
B: 2
C: 1

Can somebody help me? Thanks :)

Answer 1

Could you convert "a" to an attribute, and then use the Row Count metric against it?