Calculate number of specific item in Single select column

[ivan07]

Hi
I have a Single select column1, with options A, B, C
and would like to calculate how many A-s, B-s, C-s are there, but cannot find out how to do it with formula.
Any help would be appreciated.

Setup

• SeaTable Self-hosted, enterprise
• SeaTable Version 4.4.9:

[bennhatton]

Hi @ivan07 ,
I’m afraid it’s not directly possible, but it really depends on what you need to do with this value:

• if you just need to check it, you can create a view grouped by column1, and each group will show you the count
  
• if you need to use this value in further calculations, you can:
  • create one column by option with a simple if formula (for example if({ABC}="A",1,"") for A, and the create another column, use Data processing / Calculate accumulated value and check for the bigger value
  • use a script to fill a special column (compared to the solution above, it will allow you to store every count in the same column and you’ll be able to check the count on every row and not only on the last one)
  • replace your single select column by a link to other record column and create a table with three records : your three options. This way, you can simply create a Link formula / countlink column in this table to get this information

Probably not as simple as you wished, bu it’s the best I can think of for now… Hope this helps you anyway

Bests,
Benjamin

[ivan07]

Actually I would like to make a statistics how many A answers, B answers and C answers. Answ
ers are in Column1 and Column2. All are A, B, C, but from different type of people - thats why I have two different columns, because from the same company 2 different people can answer.

[bennhatton]

Then the last method sounds easier to me : Column1 and Column2 will both be Link columns, and in your options table, you’ll have to create two Link formula / countlinks columns (one for Column1 and one for Column2), and then a last formula column being the sum of the two previous columns (see bellow).

Doing so, you’ll be able to create for example a pie chart with the percent of every option

[ivan07]

That works great,
thanks