Forum Discussion
Beginner question : Count when several data in a row
Hello, I'm currently stuck in my small project and I have a question:
I currently have those data:
FR
BEL
FR/ES
SP
GER
FR/BEL/GER
And I would love to make a table with all the countries on the left and the count for each on the right. I basically tried the "Count function" but it doesn't work when there is several counties on the same row.
Is it possible to do it?
Thank you!!
Hi Anonymous ,
Please follow below steps to achive this:-
1.Split your column like below:-
output:-
2. Now use Group By with countries
3. Now click on Close and apply.
Final Output:-
Thanks,
Samarth
4 Replies
- truptis
Community Champion
Hi Anonymous ,
You can try this:
Result =IF(country ="FR/ES", calculate(count(columnname), filter(tablename, country ="FR" || Country ="ES")),
IF(country ="FR/BEL/GR", calculate(count(columnname), filter(tablename, country ="FR" || Country ="GR"|| Country ="BEL"),IF(country ="FR",calculate(count(columnname), filter(tablename, country ="FR"), IF(country ="BEL",calculate(count(columnname), filter(tablename, country ="BEL"), IF(country ="SP",calculate(count(columnname), filter(tablename, country ="SP"), calculate(count(columnname), filter(tablename, country = "GR")))))
Anonymous -> Please mark this as a solution if it helps you. Thank you. 
Samarth_18Hi Anonymous ,
Please follow below steps to achive this:-
1.Split your column like below:-
output:-
2. Now use Group By with countries
3. Now click on Close and apply.
Final Output:-
Thanks,
Samarth
