# Working hours filtering for dashboard

**URL:** <https://discuss.elastic.co/t/working-hours-filtering-for-dashboard/334454>\
**Category:** Kibana\
**Tags:** lens, dashboard, visualisation\
**Created:** [May 26, 2023, 4:06pm UTC](https://discuss.elastic.co/t/working-hours-filtering-for-dashboard/334454 "2023-05-26T16:06:16Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![Carlos\_Samuel](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/carlos_samuel/32/121502_2.png) [@Carlos\_Samuel](https://discuss.elastic.co/u/Carlos_Samuel)\
**Post date:** [May 26, 2023, 4:06pm UTC](https://discuss.elastic.co/t/working-hours-filtering-for-dashboard/334454/1 "2023-05-26T16:06:16Z")

</div>

Hello.

I need to create a dashboard (table) with avaiability of an ICMP Ping (collected over heartbeat), but this needs to be filtered by a specific time range: 8am ~ 6pm.

How i can do this? Does have a way on TSVB?

---

<div class="post-metadata">

**Author:** ![Alexis\_Roberson](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/alexis_roberson/32/113233_2.png) [@Alexis\_Roberson](https://discuss.elastic.co/u/Alexis_Roberson)\
**Post date:** [May 26, 2023, 4:43pm UTC](https://discuss.elastic.co/t/working-hours-filtering-for-dashboard/334454/2 "2023-05-26T16:43:58Z")

</div>

Hi @Carlos_Samuel for configuring the time range for TSVB, you can edit your visualization with the desired time range and then save it. This [FAQ](https://www.elastic.co/guide/en/kibana/8.8/tsvb.html#tsvb-faq) section in the Kibana docs seems to cover something similar to the question you're asking.  
Under,

> **How do I create dashboard drilldowns for Top N and Table visualizations?**  
> You can create dashboard drilldowns that include the specified time range for **Top N** and **Table** visualizations.

---

<div class="post-metadata">

**Author:** ![Carlos\_Samuel](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/carlos_samuel/32/121502_2.png) [@Carlos\_Samuel](https://discuss.elastic.co/u/Carlos_Samuel)\
**Post date:** [May 26, 2023, 5:15pm UTC](https://discuss.elastic.co/t/working-hours-filtering-for-dashboard/334454/3 "2023-05-26T17:15:55Z")

</div>

But will this work for my use case?

I need to have an availability percentage of ICMP pings for several days, but filtered by business hours.

I was analyzing here and I didn't see how to put this in my use case.

---

<div class="post-metadata">

**Author:** ![stephenb](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/stephenb/32/40856_2.png) [@stephenb](https://discuss.elastic.co/u/stephenb)\
**Post date:** [May 26, 2023, 7:18pm UTC](https://discuss.elastic.co/t/working-hours-filtering-for-dashboard/334454/4 "2023-05-26T19:18:59Z")

</div>

Hi @Carlos_Samuel Welcome to the community!

I think the another way to do that is create a runtime field with the hour of the day as a number and filter on that... Of course you'll have to take time zone into that.

But that would work I think

---

<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:** [June 23, 2023, 7:19pm UTC](https://discuss.elastic.co/t/working-hours-filtering-for-dashboard/334454/5 "2023-06-23T19:19:54Z")

</div>

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