Count number of unique values and present it in a diagram

[#1]

Hi

I need help to present the number of times each unique word in a collumn apperas. Like COUNTIF in excel.

COLLUMNDATA

Red

Red

Green

Red

Yellow

Yellow

RED=3 GREEN=1 YELLOW=2

I also want this presented in a diagram with one bar divided in sections for each value.

Thankful for any assistance.

Best Regards

Malte (Sweden)

[swuehl]

You just need to load your data in, then use the COLUMNDATA field as dimension and as expression

=count(COLUMNDATA)

Maybe like attached?

[#3]

Thank you for your answer.

Unfortunately I couldn't open your attachment.

Doesn't =count(COLUMNDATA) return 6 (as the sum of all)?

[swuehl · Accepted solution]

No, not if you use COLUMNDATA as dimension, this will group the results like:

Data	Count(Data)
	6
Green	1
Red	3
Yellow	2

[#5]

Thanks a lot for your help.

I think I am to tired here

Bye