TALLY

Counts the occurrences of each unique element within an array, accounting for case sensitivity.

Syntax 

TALLY(array)

Usage examples 

Example 1

Input

1
{
2
"my_action": {
3
"message": [
4
"dog",
5
"dog",
6
"cat",
7
"cat",
8
"cat",
9
"fish"
10
]
11
}
12
}

Formula

TALLY(my_action.message)

Output

1
{
2
"dog": 2,
3
"cat": 3,
4
"fish": 1
5
}
Was this helpful?