Cumulative mode in bar chart for kibana 4?


(Yu Watanabe) #1

Hi!

I was wondering is there a cumulative mode for bar chart
which existed in kibana 3?

I am considering to show the overall sum of past values for each period.

For example, if following points had

2015 apr : 1
2015 may : 2
2015 june : 1

In the bar chart , I want to show as

2015 overall total apr : 1
2015 overall total may : 3
2015 overall total june : 5

Is this still possible in kibana 4?

Thanks,
yu

--
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/837ddc0b-91fc-488d-9c02-d4571e8a4d98%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.


(Jun Ohtani) #2

Hi Yu,

I'm not sure the data which you have.
I think you can use Kibana4 .

First, you choose bar chart and use Filters aggs for X-Axis.
Query1 @timestamp:[* TO "2015-04-30"], Query2, @timestamp:[* TO
"2015-05-31"]
Then, Kibana4 display the bar chart.

And if you add Split Bars with Date Histgram for @timestamp field and
choose Interval monthly,
you can see split bar color per month.

Does it make sense?

2015-04-29 19:06 GMT+09:00 Yu Watanabe yu.w.tennis@gmail.com:

Hi!

I was wondering is there a cumulative mode for bar chart
which existed in kibana 3?

I am considering to show the overall sum of past values for each period.

For example, if following points had

2015 apr : 1
2015 may : 2
2015 june : 1

In the bar chart , I want to show as

2015 overall total apr : 1
2015 overall total may : 3
2015 overall total june : 5

Is this still possible in kibana 4?

Thanks,
yu

--
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/837ddc0b-91fc-488d-9c02-d4571e8a4d98%40googlegroups.com
https://groups.google.com/d/msgid/elasticsearch/837ddc0b-91fc-488d-9c02-d4571e8a4d98%40googlegroups.com?utm_medium=email&utm_source=footer
.
For more options, visit https://groups.google.com/d/optout.

--

Jun Ohtani
blog : http://blog.johtani.info

--
Please update your bookmarks! We have moved to https://discuss.elastic.co/

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/CAPW8A5zv45tixmw4i7bqqc_sFrn6AvUQTu-nUDvsfm6s3HtMqg%40mail.gmail.com.
For more options, visit https://groups.google.com/d/optout.


(Yu Watanabe) #3

大谷さん

質問者の渡辺です。

まず、お忙しい中回答いただきありがとうございます。

ただ、アドバイスいただいた通りに、(X-Axisのフィルタは若干変えました)
実施しましたが、うまくいきませんでした。

添付のbarchart1.pngが結果です。

私が、イメージしているのは、barchart2.pngになります。
各月のグラフが、その月までの総和になるようにしたいです。
kibana 3ではcumulativeオプションがあったので楽だったのですが、
kibana 4では四苦八苦

X-axisでDate Histogramにしないと、
x軸が月単位に分割できないのは理解できたのですが、
これだとbucketが月単位で検索され、
うまくその月までのデータを抽出できていない気がします。

もし、またアドバイスを頂けるようでしたらよろしくお願いいたします。
また、せっかくなので、LinkedInでconnectさせていただけると幸いです。

以上です。

On Fri, May 15, 2015 at 1:09 PM, Jun Ohtani johtani@gmail.com wrote:

Hi Yu,

I'm not sure the data which you have.
I think you can use Kibana4 .

First, you choose bar chart and use Filters aggs for X-Axis.
Query1 @timestamp:[* TO "2015-04-30"], Query2, @timestamp:[* TO
"2015-05-31"]
Then, Kibana4 display the bar chart.

And if you add Split Bars with Date Histgram for @timestamp field and
choose Interval monthly,
you can see split bar color per month.

Does it make sense?

2015-04-29 19:06 GMT+09:00 Yu Watanabe yu.w.tennis@gmail.com:

Hi!

I was wondering is there a cumulative mode for bar chart
which existed in kibana 3?

I am considering to show the overall sum of past values for each period.

For example, if following points had

2015 apr : 1
2015 may : 2
2015 june : 1

In the bar chart , I want to show as

2015 overall total apr : 1
2015 overall total may : 3
2015 overall total june : 5

Is this still possible in kibana 4?

Thanks,
yu

--
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/837ddc0b-91fc-488d-9c02-d4571e8a4d98%40googlegroups.com
https://groups.google.com/d/msgid/elasticsearch/837ddc0b-91fc-488d-9c02-d4571e8a4d98%40googlegroups.com?utm_medium=email&utm_source=footer
.
For more options, visit https://groups.google.com/d/optout.

--

Jun Ohtani
blog : http://blog.johtani.info

--
Please update your bookmarks! We have moved to https://discuss.elastic.co/

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/Q1zoHXUi3r0/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/CAPW8A5zv45tixmw4i7bqqc_sFrn6AvUQTu-nUDvsfm6s3HtMqg%40mail.gmail.com
https://groups.google.com/d/msgid/elasticsearch/CAPW8A5zv45tixmw4i7bqqc_sFrn6AvUQTu-nUDvsfm6s3HtMqg%40mail.gmail.com?utm_medium=email&utm_source=footer
.
For more options, visit https://groups.google.com/d/optout.

--
Yu Watanabe
渡辺 裕

LinkedIn : jp.linkedin.com/in/yuwatanabe1

--
Please update your bookmarks! We have moved to https://discuss.elastic.co/

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/CALKrq%3D%3DXu3wV6MVmekQms7Bt6UOUvnwzzVRRGXaMS%2Bg9CC3r7g%40mail.gmail.com.
For more options, visit https://groups.google.com/d/optout.


(Jun Ohtani) #4

Hi Yu,

We should move this discussion to our new web forum.

We can discuss using Japanese languages.
Please move this discussion to there.
2015/05/23 18:52 "Yu Watanabe" yu.w.tennis@gmail.com:

大谷さん

質問者の渡辺です。

まず、お忙しい中回答いただきありがとうございます。

ただ、アドバイスいただいた通りに、(X-Axisのフィルタは若干変えました)
実施しましたが、うまくいきませんでした。

添付のbarchart1.pngが結果です。

私が、イメージしているのは、barchart2.pngになります。
各月のグラフが、その月までの総和になるようにしたいです。
kibana 3ではcumulativeオプションがあったので楽だったのですが、
kibana 4では四苦八苦

X-axisでDate Histogramにしないと、
x軸が月単位に分割できないのは理解できたのですが、
これだとbucketが月単位で検索され、
うまくその月までのデータを抽出できていない気がします。

もし、またアドバイスを頂けるようでしたらよろしくお願いいたします。
また、せっかくなので、LinkedInでconnectさせていただけると幸いです。

以上です。

On Fri, May 15, 2015 at 1:09 PM, Jun Ohtani johtani@gmail.com wrote:

Hi Yu,

I'm not sure the data which you have.
I think you can use Kibana4 .

First, you choose bar chart and use Filters aggs for X-Axis.
Query1 @timestamp:[* TO "2015-04-30"], Query2, @timestamp:[* TO
"2015-05-31"]
Then, Kibana4 display the bar chart.

And if you add Split Bars with Date Histgram for @timestamp field and
choose Interval monthly,
you can see split bar color per month.

Does it make sense?

2015-04-29 19:06 GMT+09:00 Yu Watanabe yu.w.tennis@gmail.com:

Hi!

I was wondering is there a cumulative mode for bar chart
which existed in kibana 3?

I am considering to show the overall sum of past values for each period.

For example, if following points had

2015 apr : 1
2015 may : 2
2015 june : 1

In the bar chart , I want to show as

2015 overall total apr : 1
2015 overall total may : 3
2015 overall total june : 5

Is this still possible in kibana 4?

Thanks,
yu

--
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/837ddc0b-91fc-488d-9c02-d4571e8a4d98%40googlegroups.com
https://groups.google.com/d/msgid/elasticsearch/837ddc0b-91fc-488d-9c02-d4571e8a4d98%40googlegroups.com?utm_medium=email&utm_source=footer
.
For more options, visit https://groups.google.com/d/optout.

--

Jun Ohtani
blog : http://blog.johtani.info

--
Please update your bookmarks! We have moved to
https://discuss.elastic.co/

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/Q1zoHXUi3r0/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/CAPW8A5zv45tixmw4i7bqqc_sFrn6AvUQTu-nUDvsfm6s3HtMqg%40mail.gmail.com
https://groups.google.com/d/msgid/elasticsearch/CAPW8A5zv45tixmw4i7bqqc_sFrn6AvUQTu-nUDvsfm6s3HtMqg%40mail.gmail.com?utm_medium=email&utm_source=footer
.
For more options, visit https://groups.google.com/d/optout.

--
Yu Watanabe
渡辺 裕

LinkedIn : jp.linkedin.com/in/yuwatanabe1

--
Please update your bookmarks! We have moved to https://discuss.elastic.co/

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/CALKrq%3D%3DXu3wV6MVmekQms7Bt6UOUvnwzzVRRGXaMS%2Bg9CC3r7g%40mail.gmail.com
https://groups.google.com/d/msgid/elasticsearch/CALKrq%3D%3DXu3wV6MVmekQms7Bt6UOUvnwzzVRRGXaMS%2Bg9CC3r7g%40mail.gmail.com?utm_medium=email&utm_source=footer
.
For more options, visit https://groups.google.com/d/optout.

--
Please update your bookmarks! We have moved to https://discuss.elastic.co/

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/CAPW8A5y8SqR4EP%2BnBco8SiW7qirOwXF41Q5MCV7HZX%2B1FSLt%3Dg%40mail.gmail.com.
For more options, visit https://groups.google.com/d/optout.


(Yu Watanabe) #5

Hello Jun .

My apology for the error.

I will move the discussion to the site you have introduced me.

Regards,
Yu Watanabe

On Sat, May 23, 2015 at 9:06 PM, Jun Ohtani johtani@gmail.com wrote:

Hi Yu,

We should move this discussion to our new web forum.
https://discuss.elastic.co/c/in-your-native-tongue/18-category

We can discuss using Japanese languages.
Please move this discussion to there.
2015/05/23 18:52 "Yu Watanabe" yu.w.tennis@gmail.com:

大谷さん

質問者の渡辺です。

まず、お忙しい中回答いただきありがとうございます。

ただ、アドバイスいただいた通りに、(X-Axisのフィルタは若干変えました)
実施しましたが、うまくいきませんでした。

添付のbarchart1.pngが結果です。

私が、イメージしているのは、barchart2.pngになります。
各月のグラフが、その月までの総和になるようにしたいです。
kibana 3ではcumulativeオプションがあったので楽だったのですが、
kibana 4では四苦八苦

X-axisでDate Histogramにしないと、
x軸が月単位に分割できないのは理解できたのですが、
これだとbucketが月単位で検索され、
うまくその月までのデータを抽出できていない気がします。

もし、またアドバイスを頂けるようでしたらよろしくお願いいたします。
また、せっかくなので、LinkedInでconnectさせていただけると幸いです。

以上です。

On Fri, May 15, 2015 at 1:09 PM, Jun Ohtani johtani@gmail.com wrote:

Hi Yu,

I'm not sure the data which you have.
I think you can use Kibana4 .

First, you choose bar chart and use Filters aggs for X-Axis.
Query1 @timestamp:[* TO "2015-04-30"], Query2, @timestamp:[* TO
"2015-05-31"]
Then, Kibana4 display the bar chart.

And if you add Split Bars with Date Histgram for @timestamp field and
choose Interval monthly,
you can see split bar color per month.

Does it make sense?

2015-04-29 19:06 GMT+09:00 Yu Watanabe yu.w.tennis@gmail.com:

Hi!

I was wondering is there a cumulative mode for bar chart
which existed in kibana 3?

I am considering to show the overall sum of past values for each period.

For example, if following points had

2015 apr : 1
2015 may : 2
2015 june : 1

In the bar chart , I want to show as

2015 overall total apr : 1
2015 overall total may : 3
2015 overall total june : 5

Is this still possible in kibana 4?

Thanks,
yu

--
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/837ddc0b-91fc-488d-9c02-d4571e8a4d98%40googlegroups.com
https://groups.google.com/d/msgid/elasticsearch/837ddc0b-91fc-488d-9c02-d4571e8a4d98%40googlegroups.com?utm_medium=email&utm_source=footer
.
For more options, visit https://groups.google.com/d/optout.

--

Jun Ohtani
blog : http://blog.johtani.info

--
Please update your bookmarks! We have moved to
https://discuss.elastic.co/

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/Q1zoHXUi3r0/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/CAPW8A5zv45tixmw4i7bqqc_sFrn6AvUQTu-nUDvsfm6s3HtMqg%40mail.gmail.com
https://groups.google.com/d/msgid/elasticsearch/CAPW8A5zv45tixmw4i7bqqc_sFrn6AvUQTu-nUDvsfm6s3HtMqg%40mail.gmail.com?utm_medium=email&utm_source=footer
.
For more options, visit https://groups.google.com/d/optout.

--
Yu Watanabe
渡辺 裕

LinkedIn : jp.linkedin.com/in/yuwatanabe1

--
Please update your bookmarks! We have moved to
https://discuss.elastic.co/

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/CALKrq%3D%3DXu3wV6MVmekQms7Bt6UOUvnwzzVRRGXaMS%2Bg9CC3r7g%40mail.gmail.com
https://groups.google.com/d/msgid/elasticsearch/CALKrq%3D%3DXu3wV6MVmekQms7Bt6UOUvnwzzVRRGXaMS%2Bg9CC3r7g%40mail.gmail.com?utm_medium=email&utm_source=footer
.
For more options, visit https://groups.google.com/d/optout.

--
Please update your bookmarks! We have moved to https://discuss.elastic.co/

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/Q1zoHXUi3r0/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/CAPW8A5y8SqR4EP%2BnBco8SiW7qirOwXF41Q5MCV7HZX%2B1FSLt%3Dg%40mail.gmail.com
https://groups.google.com/d/msgid/elasticsearch/CAPW8A5y8SqR4EP%2BnBco8SiW7qirOwXF41Q5MCV7HZX%2B1FSLt%3Dg%40mail.gmail.com?utm_medium=email&utm_source=footer
.
For more options, visit https://groups.google.com/d/optout.

--
Yu Watanabe
渡辺 裕

LinkedIn : jp.linkedin.com/in/yuwatanabe1

--
Please update your bookmarks! We have moved to https://discuss.elastic.co/

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/CALKrq%3DkW4PiG9ajpu5%2Bsm9e-kQp63qdmR7Pn%2BRAA_FC%2BqxC1BQ%40mail.gmail.com.
For more options, visit https://groups.google.com/d/optout.


(system) #6