# Elasticsearch datasource: counting unique items in array

**URL:** <https://community.grafana.com/t/elasticsearch-datasource-counting-unique-items-in-array/100074>\
**Category:** Dashboards\
**Created:** [July 30, 2023, 3:28am UTC](https://community.grafana.com/t/elasticsearch-datasource-counting-unique-items-in-array/100074 "2023-07-30T03:28:39Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![barney2074](https://sea2.discourse-cdn.com/grafana/user_avatar/community.grafana.com/barney2074/32/8273_2.png) [@barney2074](https://community.grafana.com/u/barney2074)\
**Post date:** [July 30, 2023, 3:28am UTC](https://community.grafana.com/t/elasticsearch-datasource-counting-unique-items-in-array/100074/1 "2023-07-30T03:28:39Z")

</div>

Hi

I’m using Grafana 10.0.2 with an Elasticsearch datasource.  
I’m trying to count distinct values in a field which is an array.

So for instance, 2 rows of this field are:  
row1: “cls”: [“CAT”, “DOG”, “CAT”, “CAT”]  
row2: “cls”: [“RAT”, “ANT”, “ANT”]

So I’d like to calculate values:  
row1: cat\_count=3, dog\_count=1,rat\_count=0, ant\_count=0  
row2: cat\_count=0, dog\_count=0,rat\_count=1, ant\_count=2

I’ve tried various transform options, such as extract fields, group by etc etc with no success  
thank you in advance for any help or suggestions

Andrew