# 请教大神 kibana 如何实现按星期分组聚合

**URL:** <https://discuss.elastic.co/t/kibana/358455>\
**Category:** 中文提问与讨论\
**Created:** [April 30, 2024, 3:28am UTC](https://discuss.elastic.co/t/kibana/358455 "2024-04-30T03:28:41Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![fljcn](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/fljcn/32/133979_2.png) [@fljcn](https://discuss.elastic.co/u/fljcn)\
**Post date:** [April 30, 2024, 3:28am UTC](https://discuss.elastic.co/t/kibana/358455/1 "2024-04-30T03:28:41Z")

</div>

请教大神 实现显示星期一、星期二......星期日，所有在星期一的记录数加到一起，星期二也一样

---

<div class="post-metadata">

**Author:** ![fljcn](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/fljcn/32/133979_2.png) [@fljcn](https://discuss.elastic.co/u/fljcn)\
**Post date:** [April 30, 2024, 1:56pm UTC](https://discuss.elastic.co/t/kibana/358455/2 "2024-04-30T13:56:01Z")

</div>

![image](https://us1.discourse-cdn.com/elastic/original/3X/1/1/1155210d4212ef2f7c67da29d3f02ea7d9a7c74a.jpeg)

---

<div class="post-metadata">

**Author:** ![fljcn](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/fljcn/32/133979_2.png) [@fljcn](https://discuss.elastic.co/u/fljcn)\
**Post date:** [April 30, 2024, 1:56pm UTC](https://discuss.elastic.co/t/kibana/358455/3 "2024-04-30T13:56:42Z")

</div>

最终实现 上图效果

---

<div class="post-metadata">

**Author:** ![wangqinghuan](https://avatars.discourse-cdn.com/v4/letter/w/d26b3c/32.png) [@wangqinghuan](https://discuss.elastic.co/u/wangqinghuan)\
**Post date:** [February 10, 2025, 6:08am UTC](https://discuss.elastic.co/t/kibana/358455/4 "2025-02-10T06:08:23Z")

</div>

```auto
"aggs": {
   "perWeekDay": {
       "terms": {
           "script": "(doc['order_datetime'].date.dayOfWeek == 1 ? 'Monday' : (doc['order_datetime'].date.dayOfWeek == 2 ? 'Tuesday' : ((doc['order_datetime'].date.dayOfWeek == 3 ? 'Wednesday' : ((doc['order_datetime'].date.dayOfWeek == 4 ? 'Thursday' : ((doc['order_datetime'].date.dayOfWeek == 5 ? 'Friday' : ((doc['order_datetime'].date.dayOfWeek == 6 ? 'Saturday' : 'Sunday'))))))))))"
       }
    }
}

```