Kibana showing wrong sales per month

Elastic Stack Elasticsearch
#1

Hi All,

i have the following scenario in kibana

I am using kibana version 3.1.2.

I am getting my monthly sales wrong in kibana dashboards. let say i have
all the data for Jan on elastic search now I created one dashboard show net
sales it is displaying some part of sales in december and some part of
sales in Jan due to that I am unable to track sale per month .

Data populating to elasticsearch is fine but coming to sales getting
numbers wrong but in past year sales displayed fine from kibana. please let
me know cause for this change?

Thanks & Regards
phani

--
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/404caeea-fa0a-46c1-9a0e-26a7d2cb367b%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

#2

Sounds like a timestamp problem.

ES uses UTC and expects data to be sent to it in that format.

On 26 March 2015 at 01:14, phani.nadiminti@goktree.com wrote:

Hi All,

i have the following scenario in kibana

I am using kibana version 3.1.2.

I am getting my monthly sales wrong in kibana dashboards. let say i
have all the data for Jan on elastic search now I created one dashboard
show net sales it is displaying some part of sales in december and some
part of sales in Jan due to that I am unable to track sale per month .

Data populating to elasticsearch is fine but coming to sales getting
numbers wrong but in past year sales displayed fine from kibana. please let
me know cause for this change?

Thanks & Regards
phani

--
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/404caeea-fa0a-46c1-9a0e-26a7d2cb367b%40googlegroups.com
https://groups.google.com/d/msgid/elasticsearch/404caeea-fa0a-46c1-9a0e-26a7d2cb367b%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/CAEYi1X9JdB72nM6jN-UaU%2B2LQDeygu8Odn_Mwcv3Y%2BCr8tZzLg%40mail.gmail.com.
For more options, visit https://groups.google.com/d/optout.

#3

Hi Mark,

Thank you for the reply but in last year up to November i didn't get
this issue i got net sales fine is this feature added newly to
elasticsearch?

before November 2014 I used elasticsearch 1.1.1 after that one i
upgraded to 1.3.7 is this be a cause to this problem?

Thanks,
phani.

On Thursday, March 26, 2015 at 1:53:11 AM UTC+5:30, Mark Walkom wrote:

Sounds like a timestamp problem.

ES uses UTC and expects data to be sent to it in that format.

On 26 March 2015 at 01:14, <phani.n...@goktree.com <javascript:>> wrote:

Hi All,

i have the following scenario in kibana

I am using kibana version 3.1.2.

I am getting my monthly sales wrong in kibana dashboards. let say i
have all the data for Jan on elastic search now I created one dashboard
show net sales it is displaying some part of sales in december and some
part of sales in Jan due to that I am unable to track sale per month .

Data populating to elasticsearch is fine but coming to sales getting
numbers wrong but in past year sales displayed fine from kibana. please let
me know cause for this change?

Thanks & Regards
phani

--
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 elasticsearc...@googlegroups.com <javascript:>.
To view this discussion on the web visit
https://groups.google.com/d/msgid/elasticsearch/404caeea-fa0a-46c1-9a0e-26a7d2cb367b%40googlegroups.com
https://groups.google.com/d/msgid/elasticsearch/404caeea-fa0a-46c1-9a0e-26a7d2cb367b%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/89ec4569-848f-4080-9fa6-2589b225faad%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

#4

Timestamping is a pretty critical feature for Kibana so I am 99.999%
(recurring) that this is not an Elasticsearch issue.

Have you checked the data that's being returned to confirm that the
timestamp field in the data matches the timerange in Kibana?
i.e. is your query correct

On Wednesday, 25 March 2015 14:14:01 UTC, phani.n...@goktree.com wrote:

Hi All,

i have the following scenario in kibana

I am using kibana version 3.1.2.

I am getting my monthly sales wrong in kibana dashboards. let say i
have all the data for Jan on elastic search now I created one dashboard
show net sales it is displaying some part of sales in december and some
part of sales in Jan due to that I am unable to track sale per month .

Data populating to elasticsearch is fine but coming to sales getting
numbers wrong but in past year sales displayed fine from kibana. please let
me know cause for this change?

Thanks & Regards
phani

--
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/8b3daed8-b76d-4820-8ba2-f2eeb7b294a1%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

#5

Hi Schmorgs ,
Thanks for reply. using daily netsales also I tested, those also going
wrong and I checked my query it is fine and per year I am checking my
monthly netsales and one more point here the date field values we are
inserting as CST time.is it be a problem when we mapped to kibana.ES is
representing the values in UTC i heard.is there any change in kibana we
change time zone to CST?

date mapping is:

"created": {
"type": "date",
"format": "dateOptionalTime"
},

Thanks,
phani

On Friday, March 27, 2015 at 7:24:14 PM UTC+5:30, Schmorgs wrote:

Timestamping is a pretty critical feature for Kibana so I am 99.999%
(recurring) that this is not an Elasticsearch issue.

Have you checked the data that's being returned to confirm that the
timestamp field in the data matches the timerange in Kibana?
i.e. is your query correct

On Wednesday, 25 March 2015 14:14:01 UTC, phani.n...@goktree.com wrote:

Hi All,

i have the following scenario in kibana

I am using kibana version 3.1.2.

I am getting my monthly sales wrong in kibana dashboards. let say i
have all the data for Jan on elastic search now I created one dashboard
show net sales it is displaying some part of sales in december and some
part of sales in Jan due to that I am unable to track sale per month .

Data populating to elasticsearch is fine but coming to sales getting
numbers wrong but in past year sales displayed fine from kibana. please let
me know cause for this change?

Thanks & Regards
phani

--
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/8273ac72-22b5-437c-a5d7-c780f8b7263a%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

#6