# Usage of Array in a Kibana Data Table : issue with Count behaving as a Unique Count **URL:** \ **Category:** Kibana\ **Created:** [January 8, 2020, 9:24am UTC](https://discuss.elastic.co/t/usage-of-array-in-a-kibana-data-table-issue-with-count-behaving-as-a-unique-count/214195 "2020-01-08T09:24:50Z")\ **Posts on this page:** 9\ **Page:** 1
**Author:** ![DavidDupuy](https://avatars.discourse-cdn.com/v4/letter/d/35a633/32.png) [@DavidDupuy](https://discuss.elastic.co/u/DavidDupuy)\ **Post date:** [January 8, 2020, 9:24am UTC](https://discuss.elastic.co/t/usage-of-array-in-a-kibana-data-table-issue-with-count-behaving-as-a-unique-count/214195/1 "2020-01-08T09:24:51Z")
Hi, A am facing an issue when trying to visualise data coming from an array. For instance, my array 'Tableau\_test' contains ths below PUT /discuss\_test3/\_doc/1 { "Tableau\_test":[ "Moto", "Voiture", "Voiture", "Velo", "Velo", "Velo", "Marche", "Marche", "Marche", "Marche"] } I am expecting to see the below in a Kibana Data Table 🙂 Marche 4 Velo 3 Voiture 2 Moto 1 But the 'count' metrics seems to behave as a 'Unique count' metrics... cf. below ![image](https://us1.discourse-cdn.com/elastic/original/3X/b/a/ba61a4be3391a86f0491ab2dd6431ec7e6b68242.png) If someone can explain/help Thanks ! David ---
**Author:** ![balaji\_18](https://avatars.discourse-cdn.com/v4/letter/b/bbce88/32.png) [@balaji\_18](https://discuss.elastic.co/u/balaji_18)\ **Post date:** [January 8, 2020, 9:43am UTC](https://discuss.elastic.co/t/usage-of-array-in-a-kibana-data-table-issue-with-count-behaving-as-a-unique-count/214195/2 "2020-01-08T09:43:18Z")
Try Sum instead count ---
**Author:** ![DavidDupuy](https://avatars.discourse-cdn.com/v4/letter/d/35a633/32.png) [@DavidDupuy](https://discuss.elastic.co/u/DavidDupuy)\ **Post date:** [January 8, 2020, 2:01pm UTC](https://discuss.elastic.co/t/usage-of-array-in-a-kibana-data-table-issue-with-count-behaving-as-a-unique-count/214195/3 "2020-01-08T14:01:30Z")
Thanks. Already tried ; failing with "_The index pattern discuss\_test3 does not contain any of the following compatible field types: number_" error ---
**Author:** ![wylie](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/wylie/32/81794_2.png) [@wylie](https://discuss.elastic.co/u/wylie)\ **Post date:** [January 8, 2020, 3:26pm UTC](https://discuss.elastic.co/t/usage-of-array-in-a-kibana-data-table-issue-with-count-behaving-as-a-unique-count/214195/4 "2020-01-08T15:26:40Z")
What you showed in your example is a single document with an [array field](https://www.elastic.co/guide/en/elasticsearch/reference/current/array.html), which gets to the core of how Lucene (which is underneath Elasticsearch) represents data. This visualizations is showing the right thing- it shows that there is a single document that contains each value. ---
**Author:** ![wylie](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/wylie/32/81794_2.png) [@wylie](https://discuss.elastic.co/u/wylie)\ **Post date:** [January 8, 2020, 3:52pm UTC](https://discuss.elastic.co/t/usage-of-array-in-a-kibana-data-table-issue-with-count-behaving-as-a-unique-count/214195/5 "2020-01-08T15:52:33Z")
The "cardinality" aggregation is based on unique documents, so to get the behavior you were expecting, I would recommend indexing more than one document. ---
**Author:** ![DavidDupuy](https://avatars.discourse-cdn.com/v4/letter/d/35a633/32.png) [@DavidDupuy](https://discuss.elastic.co/u/DavidDupuy)\ **Post date:** [January 8, 2020, 5:30pm UTC](https://discuss.elastic.co/t/usage-of-array-in-a-kibana-data-table-issue-with-count-behaving-as-a-unique-count/214195/6 "2020-01-08T17:30:48Z")
Thanks Wylie, it helps a bit. I tried to change my data source ; my data source is now: PUT /discuss\_test4/\_doc/1 { "Tableau\_test":[ { "mode":"Moto", "nombre" : 1}, { "mode":"Voiture", "nombre" : 2}, { "mode":"Vélo", "nombre" : 3}, { "mode":"Marche", "nombre" : 4} ] } But I am still failing to get a visualisation in Kibana showing the below: Marche 4 Velo 3 Voiture 2 Moto 1 Cheers ---
**Author:** ![wylie](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/wylie/32/81794_2.png) [@wylie](https://discuss.elastic.co/u/wylie)\ **Post date:** [January 8, 2020, 6:39pm UTC](https://discuss.elastic.co/t/usage-of-array-in-a-kibana-data-table-issue-with-count-behaving-as-a-unique-count/214195/7 "2020-01-08T18:39:09Z")
Yes, nested objects are even less supported in Elastic and Kibana. Using multiple documents is your best bet. ---
**Author:** ![DavidDupuy](https://avatars.discourse-cdn.com/v4/letter/d/35a633/32.png) [@DavidDupuy](https://discuss.elastic.co/u/DavidDupuy)\ **Post date:** [January 13, 2020, 8:36am UTC](https://discuss.elastic.co/t/usage-of-array-in-a-kibana-data-table-issue-with-count-behaving-as-a-unique-count/214195/8 "2020-01-13T08:36:49Z")
Yeah. Thanks. We will do so. Cheers ---
**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\ **Post date:** [February 10, 2020, 8:36am UTC](https://discuss.elastic.co/t/usage-of-array-in-a-kibana-data-table-issue-with-count-behaving-as-a-unique-count/214195/9 "2020-02-10T08:36:52Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.