Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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))
1.Add list as dimension
2.Expression
Count(List)
This should work
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))
Hi Sunny,
Thank you very much for your feedback!
This worked fine!
Best regards,
Alex.
Thanks Avinash
Best regards,
Alex.
Mark the helpful and correct answers and close this thread