### Author:  [@limac](https://discuss.elastic.co/u/limac)
#### Post date: [April 4, 2014, 3:43am UTC](https://discuss.elastic.co/t/micro-analysis-in-kibana/16795/4 "2014-04-04T03:43:17Z")
how to count how many terms in docs? I mean , in Iva's example, how to get
the result of 3 , which mean there is 3 terms?
On Friday, April 4, 2014, Binh Ly [binhly\_es@yahoo.com](mailto:binhly_es@yahoo.com) wrote:
> Sounds like a terms panel on that field that contains the values 1,2,3.
>
> --
> 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/9b1a3779-f5a3-45ed-a58d-7cdb23eb717b%40googlegroups.com](https://groups.google.com/d/msgid/elasticsearch/9b1a3779-f5a3-45ed-a58d-7cdb23eb717b%40googlegroups.com)[https://groups.google.com/d/msgid/elasticsearch/9b1a3779-f5a3-45ed-a58d-7cdb23eb717b%40googlegroups.com?utm\_medium=email&utm\_source=footer](https://groups.google.com/d/msgid/elasticsearch/9b1a3779-f5a3-45ed-a58d-7cdb23eb717b%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/CAPwW3GVJwgOBn6xy2-ZAgtweCi4\_dQBthPGSFutCfDPno7%2BkcA%40mail.gmail.com](https://groups.google.com/d/msgid/elasticsearch/CAPwW3GVJwgOBn6xy2-ZAgtweCi4_dQBthPGSFutCfDPno7%2BkcA%40mail.gmail.com).
For more options, visit [https://groups.google.com/d/optout](https://groups.google.com/d/optout).
---
### Author:  [@P\_lva](https://discuss.elastic.co/u/P_lva)
#### Post date: [April 4, 2014, 7:21pm UTC](https://discuss.elastic.co/t/micro-analysis-in-kibana/16795/5 "2014-04-04T19:21:22Z")
The sql query I would use would be select count(name) from table
Elasticsearch terms would give number of 'John' but I'd like to know number
of 'John Watson' and number of 'John Lennon'.
On Thu, Apr 3, 2014 at 8:37 PM, Wang [cnwangyong@gmail.com](mailto:cnwangyong@gmail.com) wrote:
> how to count how many terms in docs? I mean , in Iva's example, how to get
> the result of 3 , which mean there is 3 terms?
>
> On Friday, April 4, 2014, Binh Ly [binhly\_es@yahoo.com](mailto:binhly_es@yahoo.com) wrote:
>
> > Sounds like a terms panel on that field that contains the values 1,2,3.
> >
> > --
> > 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/9b1a3779-f5a3-45ed-a58d-7cdb23eb717b%40googlegroups.com](https://groups.google.com/d/msgid/elasticsearch/9b1a3779-f5a3-45ed-a58d-7cdb23eb717b%40googlegroups.com)[https://groups.google.com/d/msgid/elasticsearch/9b1a3779-f5a3-45ed-a58d-7cdb23eb717b%40googlegroups.com?utm\_medium=email&utm\_source=footer](https://groups.google.com/d/msgid/elasticsearch/9b1a3779-f5a3-45ed-a58d-7cdb23eb717b%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 a topic in the
> Google Groups "elasticsearch" group.
> To unsubscribe from this topic, visit
> [https://groups.google.com/d/topic/elasticsearch/t8opboYG7UA/unsubscribe](https://groups.google.com/d/topic/elasticsearch/t8opboYG7UA/unsubscribe).
> To unsubscribe from this group and all its topics, 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/CAPwW3GV\_0Y3LJ985GQG%3DQqPFcchQGRc1hFZH8NXTNwTsgiGATQ%40mail.gmail.com](https://groups.google.com/d/msgid/elasticsearch/CAPwW3GV_0Y3LJ985GQG%3DQqPFcchQGRc1hFZH8NXTNwTsgiGATQ%40mail.gmail.com)[https://groups.google.com/d/msgid/elasticsearch/CAPwW3GV\_0Y3LJ985GQG%3DQqPFcchQGRc1hFZH8NXTNwTsgiGATQ%40mail.gmail.com?utm\_medium=email&utm\_source=footer](https://groups.google.com/d/msgid/elasticsearch/CAPwW3GV_0Y3LJ985GQG%3DQqPFcchQGRc1hFZH8NXTNwTsgiGATQ%40mail.gmail.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/CAO9TxdM\_7z17vsQjwaSinpY6w3nSHzfLikQDLSk3crJQJwr0rg%40mail.gmail.com](https://groups.google.com/d/msgid/elasticsearch/CAO9TxdM_7z17vsQjwaSinpY6w3nSHzfLikQDLSk3crJQJwr0rg%40mail.gmail.com).
For more options, visit [https://groups.google.com/d/optout](https://groups.google.com/d/optout).
---
### Author:  [@Binh\_Ly\_2](https://discuss.elastic.co/u/Binh_Ly_2)
#### Post date: [April 4, 2014, 7:55pm UTC](https://discuss.elastic.co/t/micro-analysis-in-kibana/16795/6 "2014-04-04T19:55:20Z")
You'll need to set the field name to not\_analyzed so that you can get a
distinct value for the whole field (instead of tokenized values):
{
"mappings": {
"doc": {
"properties": {
"name": {
"type": "string",
"index": "not\_analyzed"
}
}
}
}
}
After that, you can do a terms facet on name and you'll get the count that
you want.
--
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/a52300c5-e540-4231-a397-4f35db1ca977%40googlegroups.com](https://groups.google.com/d/msgid/elasticsearch/a52300c5-e540-4231-a397-4f35db1ca977%40googlegroups.com).
For more options, visit [https://groups.google.com/d/optout](https://groups.google.com/d/optout).
---
### Author:  [@P\_lva](https://discuss.elastic.co/u/P_lva)
#### Post date: [April 4, 2014, 9:05pm UTC](https://discuss.elastic.co/t/micro-analysis-in-kibana/16795/7 "2014-04-04T21:05:20Z")
Awesome Thanks Binh Ly
On Friday, April 4, 2014 2:55:20 PM UTC-5, Binh Ly wrote:
> You'll need to set the field name to not\_analyzed so that you can get a
> distinct value for the whole field (instead of tokenized values):
>
> {
> "mappings": {
> "doc": {
> "properties": {
> "name": {
> "type": "string",
> "index": "not\_analyzed"
> }
> }
> }
> }
> }
>
> After that, you can do a terms facet on name and you'll get the count that
> you want.
--
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/efc12955-99e5-4bac-b7e8-e8f04441a01a%40googlegroups.com](https://groups.google.com/d/msgid/elasticsearch/efc12955-99e5-4bac-b7e8-e8f04441a01a%40googlegroups.com).
For more options, visit [https://groups.google.com/d/optout](https://groups.google.com/d/optout).
---
### Author:  [@Mungeol\_Heo](https://discuss.elastic.co/u/Mungeol_Heo)
#### Post date: [August 27, 2014, 12:17am UTC](https://discuss.elastic.co/t/micro-analysis-in-kibana/16795/8 "2014-08-27T00:17:54Z")
The question is how the micro analysis of the Kibana cloud do this without
setting 'not\_analyzed' to the fields?
On Saturday, April 5, 2014 4:55:20 AM UTC+9, Binh Ly wrote:
> You'll need to set the field name to not\_analyzed so that you can get a
> distinct value for the whole field (instead of tokenized values):
>
> {
> "mappings": {
> "doc": {
> "properties": {
> "name": {
> "type": "string",
> "index": "not\_analyzed"
> }
> }
> }
> }
> }
>
> After that, you can do a terms facet on name and you'll get the count that
> you want.
--
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/2fc80242-d98b-4227-932a-171352453dcf%40googlegroups.com](https://groups.google.com/d/msgid/elasticsearch/2fc80242-d98b-4227-932a-171352453dcf%40googlegroups.com).
For more options, visit [https://groups.google.com/d/optout](https://groups.google.com/d/optout).
---
### Author:  [@Mungeol\_Heo](https://discuss.elastic.co/u/Mungeol_Heo)
#### Post date: [August 27, 2014, 12:27am UTC](https://discuss.elastic.co/t/micro-analysis-in-kibana/16795/9 "2014-08-27T00:27:39Z")
The question is how does the micro analysis of the Kibana can do this
without setting 'not\_analyzed' to the fields?
On Saturday, April 5, 2014 4:55:20 AM UTC+9, Binh Ly wrote:
> You'll need to set the field name to not\_analyzed so that you can get a
> distinct value for the whole field (instead of tokenized values):
>
> {
> "mappings": {
> "doc": {
> "properties": {
> "name": {
> "type": "string",
> "index": "not\_analyzed"
> }
> }
> }
> }
> }
>
> After that, you can do a terms facet on name and you'll get the count that
> you want.
--
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/a3f3fc86-17fd-48be-bf19-3a796c84b464%40googlegroups.com](https://groups.google.com/d/msgid/elasticsearch/a3f3fc86-17fd-48be-bf19-3a796c84b464%40googlegroups.com).
For more options, visit [https://groups.google.com/d/optout](https://groups.google.com/d/optout).
---
### Author:  [@system](https://discuss.elastic.co/u/system)
#### Post date: [July 6, 2017, 1:06am UTC](https://discuss.elastic.co/t/micro-analysis-in-kibana/16795/10 "2017-07-06T01:06:11Z")