---
title: Count and sort events
description: Count events per name with `countby` and sort the results alphabetically or by descending frequency with `orderby`.
url: https://coralogix.com/docs/dataprime/cookbook/count_and_sort/
product: dataengine
feature: DataPrime Language
feature_id: dataprime-language
feature_identifier: dataengine/dataprime-language
last_updated: '2026-11-02'
---

# Count and sort events by name

## 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://coralogix.com/docs/dataprime/language-reference/commands-reference/countby.md) command.

## Query

```
countby name into name_count

| orderby name
```

## Expected output

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

## 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      |