Stacked histograms of data from each event


(Tim Coote) #1

Hullo
This seems like a silly question, but I cannot find an easy solution. I
have a log file from remote sensors. Each event has values from each
sensor. The sensors are measuring various parts of a photovoltaic array. I
want to be able to plot a stacked histogram with Kibana that has the values
from each sensor in each histogram. The examples that I've seen all select
individual values from different event types and then aggregate over the
time period.

When I look at the Histogram Settings page, Panel tab, there seems to be
only one value that I can put into the histogram. How do I stack the values
from each event?

I'm using the logstash-1.3.3 flatjar version of ES and Kibana.

tia

Tim

--
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/54535a7b-b150-4b9c-8a7c-5e1e8db6c687%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.


(Eitan Vesely) #2

Hi Tim,
im facing the same issue.

were you able to find a solution?

On Wednesday, March 19, 2014 4:20:44 PM UTC+2, Tim Coote wrote:

Hullo
This seems like a silly question, but I cannot find an easy solution. I
have a log file from remote sensors. Each event has values from each
sensor. The sensors are measuring various parts of a photovoltaic array. I
want to be able to plot a stacked histogram with Kibana that has the values
from each sensor in each histogram. The examples that I've seen all select
individual values from different event types and then aggregate over the
time period.

When I look at the Histogram Settings page, Panel tab, there seems to be
only one value that I can put into the histogram. How do I stack the values
from each event?

I'm using the logstash-1.3.3 flatjar version of ES and Kibana.

tia

Tim

--
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/2a5c876c-8bd7-466e-809d-e88270dc0c16%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.


(vineeth mohan-2) #3

Hello Tim and Eitan ,

There is a way we can do it , but am pretty sure its not the standard one.
By adding different query string parameters , where each query have values
from a different sensor.

‚Äč
I believe the standard method would be to do a aggregation on first level
as term aggregation on sensor name and second level on histogram and
plotting these value as stack.
But then Kibana don't have support for this , as of now.

Thanks
Vineeth

On Sat, Jul 5, 2014 at 7:23 PM, Eitan Vesely eitanjnk@gmail.com wrote:

Hi Tim,
im facing the same issue.

were you able to find a solution?

On Wednesday, March 19, 2014 4:20:44 PM UTC+2, Tim Coote wrote:

Hullo
This seems like a silly question, but I cannot find an easy solution. I
have a log file from remote sensors. Each event has values from each
sensor. The sensors are measuring various parts of a photovoltaic array. I
want to be able to plot a stacked histogram with Kibana that has the values
from each sensor in each histogram. The examples that I've seen all select
individual values from different event types and then aggregate over the
time period.

When I look at the Histogram Settings page, Panel tab, there seems to be
only one value that I can put into the histogram. How do I stack the values
from each event?

I'm using the logstash-1.3.3 flatjar version of ES and Kibana.

tia

Tim

--
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/2a5c876c-8bd7-466e-809d-e88270dc0c16%40googlegroups.com
https://groups.google.com/d/msgid/elasticsearch/2a5c876c-8bd7-466e-809d-e88270dc0c16%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/CAGdPd5kacEpGC1ibLNqn-9pwx98kFSdh7Ex8brtBj8dd-wgE_Q%40mail.gmail.com.
For more options, visit https://groups.google.com/d/optout.


(Eitan Vesely) #4

THanks Vineeth,

This is kinda what im trying to do.
seperated my sensors into differnet types inside the same index.
im currently facing 2 issues:

  1. cannot find the right chart to present the measured values over time.
    best i can get is using the histogram yet this only shows max/min/mean
    etc...
    any idea how can i present the entire set of data?

2.issue with my logstash config file which can be viewd here:
http://justpaste.it/g40c
for some reason i only get the first "if" to work. i only get the
"energy" field into the index and the other types are disragarded.

appricate any help...
EItan

On Wednesday, March 19, 2014 4:20:44 PM UTC+2, Tim Coote wrote:

Hullo
This seems like a silly question, but I cannot find an easy solution. I
have a log file from remote sensors. Each event has values from each
sensor. The sensors are measuring various parts of a photovoltaic array. I
want to be able to plot a stacked histogram with Kibana that has the values
from each sensor in each histogram. The examples that I've seen all select
individual values from different event types and then aggregate over the
time period.

When I look at the Histogram Settings page, Panel tab, there seems to be
only one value that I can put into the histogram. How do I stack the values
from each event?

I'm using the logstash-1.3.3 flatjar version of ES and Kibana.

tia

Tim

--
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/d28e19d3-3670-4d70-b0e9-40d7be68e380%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.


(system) #5