Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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)
No, not if you use COLUMNDATA as dimension, this will group the results like:
Data | Count(Data) |
---|---|
6 | |
Green | 1 |
Red | 3 |
Yellow | 2 |
You just need to load your data in, then use the COLUMNDATA field as dimension and as expression
=count(COLUMNDATA)
Maybe like attached?
Thank you for your answer.
Unfortunately I couldn't open your attachment.
Doesn't =count(COLUMNDATA) return 6 (as the sum of all)?
No, not if you use COLUMNDATA as dimension, this will group the results like:
Data | Count(Data) |
---|---|
6 | |
Green | 1 |
Red | 3 |
Yellow | 2 |
Thanks a lot for your help.
I think I am to tired here
Bye