# Kibana Help

**URL:** <https://discuss.elastic.co/t/kibana-help/103389>\
**Category:** Kibana\
**Created:** [October 10, 2017, 2:23pm UTC](https://discuss.elastic.co/t/kibana-help/103389 "2017-10-10T14:23:59Z")\
**Posts on this page:** 7\
**Page:** 1

<div class="post-metadata">

**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:** [October 10, 2017, 2:24pm UTC](https://discuss.elastic.co/t/kibana-help/103389/1 "2017-10-10T14:24:00Z")

</div>

Hi

I am using kibana 5.1.1 version i am using date pattern field "created" which is in the format of YYYY-MM-DDTHH:mm:ss. now from this date i want to see unique record count fall on each monday.

i have written following snippet but not working. getting invalid date

doc['created'].date.dayOfWeek

please help me

---

<div class="post-metadata">

**Author:** ![Stacey\_Gammon](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/stacey_gammon/32/14025_2.png) [@Stacey\_Gammon](https://discuss.elastic.co/u/Stacey_Gammon)\
**Post date:** [October 10, 2017, 2:42pm UTC](https://discuss.elastic.co/t/kibana-help/103389/2 "2017-10-10T14:42:27Z")

</div>

I tried that in version 5.6 and it's working. Is it possible there is something wrong with your `created` field? Maybe there is an invalid date in there somewhere? Or some data that's missing a date?

Can you send some screenshots?

![35 AM](https://us1.discourse-cdn.com/elastic/original/3X/7/3/73649636bd56ed12432f5b4503a2249dcb8ba0ad.png)

 ![01 AM](https://us1.discourse-cdn.com/elastic/original/3X/8/1/811dc04386a8daac86c5fb234dbd0239b7721bc9.png)

---

<div class="post-metadata">

**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:** [October 10, 2017, 3:31pm UTC](https://discuss.elastic.co/t/kibana-help/103389/3 "2017-10-10T15:31:33Z")

</div>

Hi

Thank you somuch for reply i was using painless previously that is the reason i didn't get it work. now it is working on my date field but on x-axis it is showing day of theweek value as 0 instead of 1can you please tell me why it is showing 0.

![histogram](https://us1.discourse-cdn.com/elastic/original/3X/9/c/9cf8c58398a8be738e50c957b74df05e0df29035.png)

---

<div class="post-metadata">

**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:** [October 10, 2017, 3:38pm UTC](https://discuss.elastic.co/t/kibana-help/103389/4 "2017-10-10T15:38:15Z")

</div>

please advice me is this expression correct

doc['created'].date.dayOfWeek == 1

so i am using this one in histogram. if day of the week is monday then i am getting unique counts of my users and displaying in bar graph

---

<div class="post-metadata">

**Author:** ![Stacey\_Gammon](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/stacey_gammon/32/14025_2.png) [@Stacey\_Gammon](https://discuss.elastic.co/u/Stacey_Gammon)\
**Post date:** [October 10, 2017, 4:48pm UTC](https://discuss.elastic.co/t/kibana-help/103389/5 "2017-10-10T16:48:11Z")

</div>

Yes, that expression should work:

![37 PM](https://us1.discourse-cdn.com/elastic/original/3X/f/f/ff0cd8cc4680448b85d4eaad155dc3043960aa9f.png) ![24 PM](https://us1.discourse-cdn.com/elastic/original/3X/6/2/62dd3d4b0e0f9f5f77b00455b359c03fff5baf8f.png)

---

<div class="post-metadata">

**Author:** ![Minakshi\_Gundye](https://avatars.discourse-cdn.com/v4/letter/m/3d9bf3/32.png) [@Minakshi\_Gundye](https://discuss.elastic.co/u/Minakshi_Gundye)\
**Post date:** [October 11, 2017, 5:21pm UTC](https://discuss.elastic.co/t/kibana-help/103389/6 "2017-10-11T17:21:58Z")

</div>

Hi, Im fresher.. I have created one dashboard in kibana and i have installed sentinl plugging for creating reports.. But i didn't found any solution for this. Can anyone help me please.

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\
**Post date:** [November 8, 2017, 5:22pm UTC](https://discuss.elastic.co/t/kibana-help/103389/7 "2017-11-08T17:22:26Z")

</div>

Closed on November 8, 2017, 5:22pm UTC

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.