How do I count the amount of number of individual references? (See Thread)

[Anonymous]

I am trying to work out an expression that would count the amount of times a reference appears in a table. An example is shown:

List

HELLO

HELLO

GOODBYE

GOODBYE

GOODBYE

HELLO

GOODBYE

Desired Outcome: Hello: x3    Goodbye: x4

The expressions I have tried are incredibly basic and I'm sure this post may seem borederline stupid for some seasoned devs however I have tried the COUNT and SUM function, as well as the COUNTIF function, but I cannot seem to get the desired outcome.

Thanks and best regards,

Alex BG.

[avinashelite]

1.Add list as dimension

2.Expression

Count(List)

This should work

[sunny_talwar · Accepted solution]

You need this in a text box object or table? For table, you can try this

Dimension

List

Expression

Count(List)

For Text Box, you are try this

=Concat(Aggr(List & ': x' & Count(List), List), Chr(10))

[Anonymous]

Hi Sunny,

Thank you very much for your feedback!

This worked fine!

Best regards,

Alex.

[Anonymous]

Thanks Avinash

Best regards,

Alex.

[avinashelite]

Mark the helpful and correct answers and close this thread