Copy as Markdown[Open in ChatGPT](https://chatgpt.com/?q=Read%20https%3A%2F%2Fdocs-docusaurus.kinsta.page%2Fdataprime%2Fcookbook%2Fcount_and_sort.md%20and%20help%20me%20with%20my%20question%20about%20this%20Coralogix%20documentation%20page.)[Open in Claude](https://claude.ai/new?q=Read%20https%3A%2F%2Fdocs-docusaurus.kinsta.page%2Fdataprime%2Fcookbook%2Fcount_and_sort.md%20and%20help%20me%20with%20my%20question%20about%20this%20Coralogix%20documentation%20page.)

# Count and sort events by name

## Problem / Use case[​](#problem--use-case "Direct link to Problem / Use case")

You want to count how many times each name appears in your logs and then sort the result alphabetically by name. This can be accomplished with the [`countBy`](https://docs-docusaurus.kinsta.page/dataprime/language-reference/commands-reference/countby/.md) command.

## Query[​](#query "Direct link to Query")

```
countby name into name_count

| orderby name
```

## Expected output[​](#expected-output "Direct link to Expected output")

| name                         | name\_count |
| ---------------------------- | ----------- |
| currencyservice-server       | 35936334    |
| emailservice-server          | 243684      |
| paymentservice-charge        | 243683      |
| paymentservice-server        | 386842      |
| recommendationservice-server | 6685255     |
| null                         | 212302149   |

## Variations[​](#variations "Direct link to Variations")

To sort by descending frequency instead:

```
countby name into name_count

| orderby name_count desc
```

| name                         | name\_count |
| ---------------------------- | ----------- |
| null                         | 212277571   |
| currencyservice-server       | 35932632    |
| recommendationservice-server | 6684555     |
| paymentservice-server        | 386798      |
| emailservice-server          | 243653      |
| paymentservice-charge        | 243652      |