# Kibana showing wrong sales per month **URL:** \ **Category:** Elasticsearch\ **Created:** [March 25, 2015, 2:14pm UTC](https://discuss.elastic.co/t/kibana-showing-wrong-sales-per-month/22894 "2015-03-25T14:14:00Z")\ **Posts on this page:** 6\ **Page:** 1
**Author:** ![Phani\_Nadiminti](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/phani_nadiminti/32/45381_2.png) [@Phani\_Nadiminti](https://discuss.elastic.co/u/Phani_Nadiminti)\ **Post date:** [March 25, 2015, 2:14pm UTC](https://discuss.elastic.co/t/kibana-showing-wrong-sales-per-month/22894/1 "2015-03-25T14:14:00Z")
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](mailto: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). For more options, visit [https://groups.google.com/d/optout](https://groups.google.com/d/optout). ---
**Author:** ![warkolm](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/warkolm/32/39224_2.png) [@warkolm](https://discuss.elastic.co/u/warkolm)\ **Post date:** [March 25, 2015, 8:22pm UTC](https://discuss.elastic.co/t/kibana-showing-wrong-sales-per-month/22894/2 "2015-03-25T20:22:40Z")
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](mailto: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 Elasticsearch 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](mailto: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) > [https://groups.google.com/d/msgid/elasticsearch/404caeea-fa0a-46c1-9a0e-26a7d2cb367b%40googlegroups.com?utm\_medium=email&utm\_source=footer](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](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/CAEYi1X9JdB72nM6jN-UaU%2B2LQDeygu8Odn\_Mwcv3Y%2BCr8tZzLg%40mail.gmail.com](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](https://groups.google.com/d/optout). ---
**Author:** ![Phani\_Nadiminti](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/phani_nadiminti/32/45381_2.png) [@Phani\_Nadiminti](https://discuss.elastic.co/u/Phani_Nadiminti)\ **Post date:** [March 27, 2015, 9:22am UTC](https://discuss.elastic.co/t/kibana-showing-wrong-sales-per-month/22894/3 "2015-03-27T09:22:56Z")
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](mailto: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 Elasticsearch 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](mailto:elasticsearc...@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) > > [https://groups.google.com/d/msgid/elasticsearch/404caeea-fa0a-46c1-9a0e-26a7d2cb367b%40googlegroups.com?utm\_medium=email&utm\_source=footer](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](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/89ec4569-848f-4080-9fa6-2589b225faad%40googlegroups.com](https://groups.google.com/d/msgid/elasticsearch/89ec4569-848f-4080-9fa6-2589b225faad%40googlegroups.com). For more options, visit [https://groups.google.com/d/optout](https://groups.google.com/d/optout). ---
**Author:** ![Schmorgs1](https://avatars.discourse-cdn.com/v4/letter/s/9f8e36/32.png) [@Schmorgs1](https://discuss.elastic.co/u/Schmorgs1)\ **Post date:** [March 27, 2015, 1:54pm UTC](https://discuss.elastic.co/t/kibana-showing-wrong-sales-per-month/22894/4 "2015-03-27T13:54:14Z")
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](mailto: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 Elasticsearch 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](mailto: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](https://groups.google.com/d/msgid/elasticsearch/8b3daed8-b76d-4820-8ba2-f2eeb7b294a1%40googlegroups.com). For more options, visit [https://groups.google.com/d/optout](https://groups.google.com/d/optout). ---
**Author:** ![Phani\_Nadiminti](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/phani_nadiminti/32/45381_2.png) [@Phani\_Nadiminti](https://discuss.elastic.co/u/Phani_Nadiminti)\ **Post date:** [March 31, 2015, 1:31pm UTC](https://discuss.elastic.co/t/kibana-showing-wrong-sales-per-month/22894/5 "2015-03-31T13:31:10Z")
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](mailto: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 Elasticsearch 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](mailto: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](https://groups.google.com/d/msgid/elasticsearch/8273ac72-22b5-437c-a5d7-c780f8b7263a%40googlegroups.com). For more options, visit [https://groups.google.com/d/optout](https://groups.google.com/d/optout). ---
**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\ **Post date:** [July 6, 2017, 12:22am UTC](https://discuss.elastic.co/t/kibana-showing-wrong-sales-per-month/22894/6 "2017-07-06T00:22:45Z")