Hi. I have a search result returned as the following:
name type col_1 col_2 col3
==== ==== ===== ===== =====
N1 T1 A A C
N1 T2 A B D
N2 T1 D D C
How to count numbers of "A", "B", "C", and "D"? For example, the result looks like this:
new_field count
========= =====
A 2
B 1
C 2
D 3
Any helps are great appreciated.
Thanks.
Try this
base search | fields - type | untable name fields values | stats count by values
Try this
base search | fields - type | untable name fields values | stats count by values
wow, thank you very much for your help!!!