Micro Analysis in Kibana


(P lva) #1

Hello everyone,

I'm using kibana and would like to add a panel that basically counts the
values in column. (Similar to micro analysis when you select the field).

value 1
value 2
value 2
value 3
value 1

Result

value 1 = 2
value 2 = 2
value 3 = 1

Which panel can one use to get this information ?

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.
To view this discussion on the web visit https://groups.google.com/d/msgid/elasticsearch/75d0a046-2332-4814-9bc8-2b239df5e836%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.


(Binh Ly-2) #2

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.
To view this discussion on the web visit https://groups.google.com/d/msgid/elasticsearch/9b1a3779-f5a3-45ed-a58d-7cdb23eb717b%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.


(Yong Wang) #3

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 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<javascript:_e(%7B%7D,'cvml','elasticsearch%2Bunsubscribe@googlegroups.com');>
.
To view this discussion on the web visit
https://groups.google.com/d/msgid/elasticsearch/9b1a3779-f5a3-45ed-a58d-7cdb23eb717b%40googlegroups.comhttps://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.

--
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.
To view this discussion on the web visit https://groups.google.com/d/msgid/elasticsearch/CAPwW3GV_0Y3LJ985GQG%3DQqPFcchQGRc1hFZH8NXTNwTsgiGATQ%40mail.gmail.com.
For more options, visit https://groups.google.com/d/optout.


(Yong Wang) #4

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 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<javascript:_e(%7B%7D,'cvml','elasticsearch%2Bunsubscribe@googlegroups.com');>
.
To view this discussion on the web visit
https://groups.google.com/d/msgid/elasticsearch/9b1a3779-f5a3-45ed-a58d-7cdb23eb717b%40googlegroups.comhttps://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.

--
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.
To view this discussion on the web visit https://groups.google.com/d/msgid/elasticsearch/CAPwW3GVJwgOBn6xy2-ZAgtweCi4_dQBthPGSFutCfDPno7%2BkcA%40mail.gmail.com.
For more options, visit https://groups.google.com/d/optout.


(P lva) #5

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 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 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.

To view this discussion on the web visit
https://groups.google.com/d/msgid/elasticsearch/9b1a3779-f5a3-45ed-a58d-7cdb23eb717b%40googlegroups.comhttps://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.

--
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.
To unsubscribe from this group and all its topics, send an email to
elasticsearch+unsubscribe@googlegroups.com.
To view this discussion on the web visit
https://groups.google.com/d/msgid/elasticsearch/CAPwW3GV_0Y3LJ985GQG%3DQqPFcchQGRc1hFZH8NXTNwTsgiGATQ%40mail.gmail.comhttps://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.

--
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.
To view this discussion on the web visit https://groups.google.com/d/msgid/elasticsearch/CAO9TxdM_7z17vsQjwaSinpY6w3nSHzfLikQDLSk3crJQJwr0rg%40mail.gmail.com.
For more options, visit https://groups.google.com/d/optout.


(Binh Ly-2) #6

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.
To view this discussion on the web visit https://groups.google.com/d/msgid/elasticsearch/a52300c5-e540-4231-a397-4f35db1ca977%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.


(P lva) #7

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.
To view this discussion on the web visit https://groups.google.com/d/msgid/elasticsearch/efc12955-99e5-4bac-b7e8-e8f04441a01a%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.


(Mungeol Heo) #8

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.
To view this discussion on the web visit https://groups.google.com/d/msgid/elasticsearch/2fc80242-d98b-4227-932a-171352453dcf%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.


(Mungeol Heo) #9

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.
To view this discussion on the web visit https://groups.google.com/d/msgid/elasticsearch/a3f3fc86-17fd-48be-bf19-3a796c84b464%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.


(system) #10