# A chart to show: hour of the day vs delayed flight vs ticket cancelation

**URL:** <https://discuss.elastic.co/t/a-chart-to-show-hour-of-the-day-vs-delayed-flight-vs-ticket-cancelation/186781>\
**Category:** Kibana\
**Created:** [June 20, 2019, 11:57pm UTC](https://discuss.elastic.co/t/a-chart-to-show-hour-of-the-day-vs-delayed-flight-vs-ticket-cancelation/186781 "2019-06-20T23:57:44Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![adrianovieira](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/adrianovieira/32/48479_2.png) [@adrianovieira](https://discuss.elastic.co/u/adrianovieira)\
**Post date:** [June 20, 2019, 11:57pm UTC](https://discuss.elastic.co/t/a-chart-to-show-hour-of-the-day-vs-delayed-flight-vs-ticket-cancelation/186781/1 "2019-06-20T23:57:45Z")

</div>

It should be good a dashboard like this.

So, how to build a chart from ELK demo data to show:

1. hour of the day (via timestamp) **vs** flight delay **vs** ticket cancellation;
2. hour of the day (via timestamp) **vs** flight delay **vs** delay type **vs** ticket cancellation

Could you point me some tips in order to create this kind of chart?

Thank you in advance.

---

<div class="post-metadata">

**Author:** ![wylie](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/wylie/32/81794_2.png) [@wylie](https://discuss.elastic.co/u/wylie)\
**Post date:** [June 28, 2019, 2:54pm UTC](https://discuss.elastic.co/t/a-chart-to-show-hour-of-the-day-vs-delayed-flight-vs-ticket-cancelation/186781/2 "2019-06-28T14:54:29Z")

</div>

Hi @adrianovieira! Sorry for the late reply, you may be interested in using a combination of Split Charts and Split Series with the Terms aggregation. For example, I've created this chart based on your 2nd request.

X-Axis: Timestamp  
Split chart: Terms of Cancellation (because this is a boolean, it will only be two terms)  
Split series: Terms of Delay (boolean again, so two terms)  
Split series: Top 5 Terms of DelayType

You can modify this to visualize your first chart request removing the DelayType.

![31](https://us1.discourse-cdn.com/elastic/original/3X/d/3/d30d1aaf7d678dc97a34398488485eb51f2a2f10.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:** [July 26, 2019, 2:54pm UTC](https://discuss.elastic.co/t/a-chart-to-show-hour-of-the-day-vs-delayed-flight-vs-ticket-cancelation/186781/3 "2019-07-26T14:54:31Z")

</div>

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