count example

[a1003520]

could you explain how the count([column1] for [column2]) really work with an example.
Also can sum([column1] for [column2]) also work? And with example if possible

[AnalyticsWithJay]

Location          Employee           
US                   John
US                   Nancy
Canada            Alex

Code Select Expand

count([Employee] for report)
Result: 3

Code Select Expand

count([Employee] for [Location])
Result:
US          2
Canada   1

It's basically a count, and you specify what you want to group the count by. If you wanted to further break it down by State/Province, you could do count([Employee] for [Location],[State]).

You could use the for statement with sum, max, min, etc. They work in the exact same way. For example, if you wanted a breakdown of revenue by retailer you could total([revenue] for [retailer]).