# Kibana: Create Term panels with date fields (Weekday, Month, Year, etc)?

**URL:** <https://discuss.elastic.co/t/kibana-create-term-panels-with-date-fields-weekday-month-year-etc/20495>\
**Category:** Elasticsearch\
**Created:** [October 30, 2014, 11:35am UTC](https://discuss.elastic.co/t/kibana-create-term-panels-with-date-fields-weekday-month-year-etc/20495 "2014-10-30T11:35:37Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Gabriel\_Birke](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/gabriel_birke/32/1145_2.png) [@Gabriel\_Birke](https://discuss.elastic.co/u/Gabriel_Birke)\
**Post date:** [October 30, 2014, 11:35am UTC](https://discuss.elastic.co/t/kibana-create-term-panels-with-date-fields-weekday-month-year-etc/20495/1 "2014-10-30T11:35:37Z")

</div>

I have data with a field called "created\_on" with "type":"date" in  
Elasticsearch (format is date\_time\_no\_millis). Is it possible to create  
term panels that show "year", "month" or "weekday" terms?

If that's not possible I imagine I could create a mapping for the  
"created\_on" field that defines sub-fields like "created\_on.month",  
"created\_on.weekday", etc. Can anyone give me an example on how such a  
mapping would look like?

--  
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/c8c64863-4a34-48b9-b7c4-2ef5bfc2da52%40googlegroups.com](https://groups.google.com/d/msgid/elasticsearch/c8c64863-4a34-48b9-b7c4-2ef5bfc2da52%40googlegroups.com).  
For more options, visit [https://groups.google.com/d/optout](https://groups.google.com/d/optout).

---

<div class="post-metadata">

**Author:** ![jay224](https://avatars.discourse-cdn.com/v4/letter/j/dc4da7/32.png) [@jay224](https://discuss.elastic.co/u/jay224)\
**Post date:** [October 21, 2016, 6:54pm UTC](https://discuss.elastic.co/t/kibana-create-term-panels-with-date-fields-weekday-month-year-etc/20495/2 "2016-10-21T18:54:05Z")

</div>

I am not sure what are you using for ingesting data, if you are using Logstash you can use filter Date and then add terms weekday, month etc like this

date {  
match =\> ["starttime", "YYYY-MM-dd HH:mm:ss"]  
timezone =\> "UTC"  
target =\> "@timestamp"  
add\_field =\> {"[weekday]" =\> "%{+EEEEE}"}  
add\_field =\> {"[month]" =\> "%{+MMM}"}  
add\_field =\> {"[year]" =\> "%{+yyyy}"}

```
  }
```

---

<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:** [July 5, 2017, 10:10pm UTC](https://discuss.elastic.co/t/kibana-create-term-panels-with-date-fields-weekday-month-year-etc/20495/3 "2017-07-05T22:10:26Z")

</div>