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 3Tableau
~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 4array("ExCo",3,2,1).cnt // Returns 3nodes().count
// Returns the number of nodes within the current filtertSQL
~COUNT!~(‹field›)
SELECT COUNT(CustomerID)
FROM OrdersDataPython
~len!~(‹array›)
len(["ExCo",3,2,1]) # Returns 4Last updated
Was this helpful?