Count
See also Strings > Length
Excel
=~COUNTA!~(‹range›) (counts all values in the array) OR =~COUNT!~(‹range›) (counts numbers in the range only)
=COUNTA(B:B) // {"ExCo",3,2,1} returns 4
=COUNT(C:C) // {"ExCo",3,2,1} returns 3
Tableau
~COUNT!~(‹field›)
COUNT([Customer ID])
Alteryx
Use the Summarize Tool (in the Transform palette):
(group by field, count by measure).
OrgVue
‹array›.~count!~ (counts all items in the array) OR ‹array›.~cnt!~ (counts numbers in the array only)
array("ExCo",3,2,1).count // Returns 4
array("ExCo",3,2,1).cnt // Returns 3
nodes().count
// Returns the number of nodes within the current filter
tSQL
~COUNT!~(‹field›)
SELECT COUNT(CustomerID)
FROM OrdersData
Python
~len!~(‹array›)
len(["ExCo",3,2,1]) # Returns 4
Last updated
Was this helpful?