# How are missing values treated with new cardinality feature **URL:** \ **Category:** Elasticsearch\ **Created:** [April 11, 2014, 4:30am UTC](https://discuss.elastic.co/t/how-are-missing-values-treated-with-new-cardinality-feature/16946 "2014-04-11T04:30:50Z")\ **Posts on this page:** 3\ **Page:** 1
**Author:** ![H\_Sun](https://avatars.discourse-cdn.com/v4/letter/h/4da419/32.png) [@H\_Sun](https://discuss.elastic.co/u/H_Sun)\ **Post date:** [April 11, 2014, 4:30am UTC](https://discuss.elastic.co/t/how-are-missing-values-treated-with-new-cardinality-feature/16946/1 "2014-04-11T04:30:50Z")
Hi, With the new cardinality feature introduced in 1.1.0. How are missing values treated? For example, in a data set with a field "city", are all rows with no "city" value counted as 1? -thanks -- You received this message because you are subscribed to the Google Groups "elasticsearch" group. To unsubscribe from this group and stop receiving emails from it, send an email to [elasticsearch+unsubscribe@googlegroups.com](mailto:elasticsearch+unsubscribe@googlegroups.com). To view this discussion on the web visit [https://groups.google.com/d/msgid/elasticsearch/832df04c-a216-4964-b514-37e4bed0a25e%40googlegroups.com](https://groups.google.com/d/msgid/elasticsearch/832df04c-a216-4964-b514-37e4bed0a25e%40googlegroups.com). For more options, visit [https://groups.google.com/d/optout](https://groups.google.com/d/optout). ---
**Author:** ![spinscale](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/spinscale/32/25011_2.png) [@spinscale](https://discuss.elastic.co/u/spinscale)\ **Post date:** [April 21, 2014, 11:57am UTC](https://discuss.elastic.co/t/how-are-missing-values-treated-with-new-cardinality-feature/16946/2 "2014-04-21T11:57:47Z")
Hey only real values are counted, missing is not counted as 1 IIRC --Alex On Fri, Apr 11, 2014 at 6:30 AM, H Sun [sunh11373@gmail.com](mailto:sunh11373@gmail.com) wrote: > Hi, > > With the new cardinality feature introduced in 1.1.0. How are missing > values treated? For example, in a data set with a field "city", are all > rows with no "city" value counted as 1? > > -thanks > > -- > You received this message because you are subscribed to the Google Groups > "elasticsearch" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [elasticsearch+unsubscribe@googlegroups.com](mailto:elasticsearch+unsubscribe@googlegroups.com). > To view this discussion on the web visit > [https://groups.google.com/d/msgid/elasticsearch/832df04c-a216-4964-b514-37e4bed0a25e%40googlegroups.com](https://groups.google.com/d/msgid/elasticsearch/832df04c-a216-4964-b514-37e4bed0a25e%40googlegroups.com)[https://groups.google.com/d/msgid/elasticsearch/832df04c-a216-4964-b514-37e4bed0a25e%40googlegroups.com?utm\_medium=email&utm\_source=footer](https://groups.google.com/d/msgid/elasticsearch/832df04c-a216-4964-b514-37e4bed0a25e%40googlegroups.com?utm_medium=email&utm_source=footer) > . > For more options, visit [https://groups.google.com/d/optout](https://groups.google.com/d/optout). -- You received this message because you are subscribed to the Google Groups "elasticsearch" group. To unsubscribe from this group and stop receiving emails from it, send an email to [elasticsearch+unsubscribe@googlegroups.com](mailto:elasticsearch+unsubscribe@googlegroups.com). To view this discussion on the web visit [https://groups.google.com/d/msgid/elasticsearch/CAGCwEM9PjBg-6D2172ip-7BS\_zB0D%3D7eW6ntGb%3DkurQ%2BJi9VVQ%40mail.gmail.com](https://groups.google.com/d/msgid/elasticsearch/CAGCwEM9PjBg-6D2172ip-7BS_zB0D%3D7eW6ntGb%3DkurQ%2BJi9VVQ%40mail.gmail.com). For more options, visit [https://groups.google.com/d/optout](https://groups.google.com/d/optout). ---
**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\ **Post date:** [July 6, 2017, 1:34am UTC](https://discuss.elastic.co/t/how-are-missing-values-treated-with-new-cardinality-feature/16946/3 "2017-07-06T01:34:39Z")