# Kibana visualization perform calculation off user date input

**URL:** https://discuss.elastic.co/t/kibana-visualization-perform-calculation-off-user-date-input/310040
**Category:** Kibana
**Created:** [July 19, 2022, 3:27pm UTC](https://discuss.elastic.co/t/kibana-visualization-perform-calculation-off-user-date-input/310040 "2022-07-19T15:27:53Z")
**Posts on this page:** 3
**Page:** 1

<div class="post-metadata">

### Author: ![ryan108](https://avatars.discourse-cdn.com/v4/letter/r/4491bb/32.png) [@ryan108](https://discuss.elastic.co/u/ryan108)
#### Post date: [July 19, 2022, 3:27pm UTC](https://discuss.elastic.co/t/kibana-visualization-perform-calculation-off-user-date-input/310040/1 "2022-07-19T15:27:53Z")

</div>

I know we use the datepicker in visualizations to show only that date range in results, but is there a way to do more complex calculations with the user date input? Specifically I've been asked by a customer to show:  
"the count of items where topic.keyword = “order”, and create date is date = input date, divided by count of items where topic.keyword = “order”, and create date \> input date"  
Does kibana have any capability like this where we can use the same date input twice? Nothing I've come across yet suggests this is possible though I am new to elassticsearch and kibana. Would appreciate if someone could point me in the right direction

---

<div class="post-metadata">

### Author: ![Marius\_Dragomir](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/marius_dragomir/32/42087_2.png) [@Marius\_Dragomir](https://discuss.elastic.co/u/Marius_Dragomir)
#### Post date: [July 23, 2022, 5:38pm UTC](https://discuss.elastic.co/t/kibana-visualization-perform-calculation-off-user-date-input/310040/2 "2022-07-23T17:38:33Z")

</div>

This exact thing is not possible in Kibana and Elasticsearch as it deals a lot with data aggregations (buckets). You can use it to see something like a trend in orders, based on each day by increasing the time interval in the timepicker and setting the date histogram interval in a chart to 1 day.

---

<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: [August 20, 2022, 5:39pm UTC](https://discuss.elastic.co/t/kibana-visualization-perform-calculation-off-user-date-input/310040/3 "2022-08-20T17:39:28Z")

</div>

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