# Use days\_of\_month

**URL:** <https://discuss.elastic.co/t/use-days-of-month/377907>\
**Category:** Kibana\
**Tags:** lens\
**Created:** [May 7, 2025, 1:18pm UTC](https://discuss.elastic.co/t/use-days-of-month/377907 "2025-05-07T13:18:48Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![elasticforme](https://avatars.discourse-cdn.com/v4/letter/e/f05b48/32.png) [@elasticforme](https://discuss.elastic.co/u/elasticforme)\
**Post date:** [May 7, 2025, 1:18pm UTC](https://discuss.elastic.co/t/use-days-of-month/377907/1 "2025-05-07T13:18:48Z")

</div>

Hi  
I would like to create line graph in Lens and use  
sum(price)/days\_of\_month

how do I get days\_of\_month ? which is 31,28,31,30 etc..

---

<div class="post-metadata">

**Author:** ![Marco\_Liberati](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/marco_liberati/32/82953_2.png) [@Marco\_Liberati](https://discuss.elastic.co/u/Marco_Liberati)\
**Post date:** [May 8, 2025, 9:55am UTC](https://discuss.elastic.co/t/use-days-of-month/377907/2 "2025-05-08T09:55:51Z")

</div>

Hi @elasticforme

I've opened a feature request for this kind of issue here: [[Lens] Make `interval()` handle calendar intervals · Issue #220484 · elastic/kibana · GitHub](https://github.com/elastic/kibana/issues/220484) so you can track it.