# Visualize a utilize of bot execution during a day\\

**URL:** <https://discuss.elastic.co/t/visualize-a-utilize-of-bot-execution-during-a-day/318986>\
**Category:** Kibana\
**Tags:** elastic-stack-alerting\
**Created:** [November 15, 2022, 5:10pm UTC](https://discuss.elastic.co/t/visualize-a-utilize-of-bot-execution-during-a-day/318986 "2022-11-15T17:10:05Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![yonaten08](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/yonaten08/32/99659_2.png) [@yonaten08](https://discuss.elastic.co/u/yonaten08)\
**Post date:** [November 15, 2022, 5:10pm UTC](https://discuss.elastic.co/t/visualize-a-utilize-of-bot-execution-during-a-day/318986/1 "2022-11-15T17:10:05Z")

</div>

hi all,  
quite new in Kibana and need some help,  
I'm trying to visualize a utilization of bots during a day\days (depended on filter @timestemp) ,  
when a bot ended his run he log is total execution time in second, and he can run multiple times a day.  
cant find a way to visualize a each bot utilization ratio to day ,  
example:  
y-axis : 0 - 100 % ( seconds in a day)  
x-axis : @timestemp (each day)  
split : sum(total execution time in second) of each robot

thanks in advance

---

<div class="post-metadata">

**Author:** ![devon.thomson](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/devon.thomson/32/85468_2.png) [@devon.thomson](https://discuss.elastic.co/u/devon.thomson)\
**Post date:** [November 15, 2022, 7:51pm UTC](https://discuss.elastic.co/t/visualize-a-utilize-of-bot-execution-during-a-day/318986/2 "2022-11-15T19:51:42Z")

</div>

Hi @yonaten08. This very much depends on how your data is structured. I assume that each document represents one run of one bot. If so, it's pretty easy to set this chart up using [Lens](https://www.elastic.co/guide/en/kibana/current/lens.html).

**X axis** I would use date histogram on the `@timestamp` field with the minimum interval set to 1 day

**Y Axis** I would use the Lens formula to `sum(total execution time) / seconds in a day`, and set the formatting to percent.

**Split** on `robot id` or any other unique identifier.

An extra step to make this nicer would be to use a `reference line` in Lens set to 100% to make sure that you are always in the range of 0-100%.

I know this isn't quite the same as your data, but here's an example of how it could look using our demo data.

 ![Screen Shot 2022-11-15 at 2.49.58 PM](https://us1.discourse-cdn.com/elastic/original/3X/1/6/16008e7507e2e779b528e90398064cd098740a54.png)

---

<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:** [December 13, 2022, 6:05pm UTC](https://discuss.elastic.co/t/visualize-a-utilize-of-bot-execution-during-a-day/318986/3 "2022-12-13T18:05:14Z")

</div>



---

<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:** [January 10, 2023, 6:05pm UTC](https://discuss.elastic.co/t/visualize-a-utilize-of-bot-execution-during-a-day/318986/4 "2023-01-10T18:05:58Z")

</div>

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