# How to create a Kibana Visualization to show jobs failing over last 7 days

**URL:** <https://discuss.elastic.co/t/how-to-create-a-kibana-visualization-to-show-jobs-failing-over-last-7-days/51217>\
**Category:** Kibana\
**Created:** [May 28, 2016, 10:25am UTC](https://discuss.elastic.co/t/how-to-create-a-kibana-visualization-to-show-jobs-failing-over-last-7-days/51217 "2016-05-28T10:25:00Z")\
**Posts on this page:** 1\
**Showing post:** 2

<div class="post-metadata">

**Author:** ![LeeDr](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/leedr/32/9289_2.png) [@LeeDr](https://discuss.elastic.co/u/LeeDr)\
**Post date:** [June 2, 2016, 2:37pm UTC](https://discuss.elastic.co/t/how-to-create-a-kibana-visualization-to-show-jobs-failing-over-last-7-days/51217/2 "2016-06-02T14:37:54Z")

</div>

I think the easiest thing to do (although not exactly what you're looking for) is to create a Data Table visualization.

In this example, I've filtered on response codes of 404. In your case you would filter on your failures code.

Then I did a split rows bucket aggregation using Terms, 'ip' (which would be like your Job ID.

Then you can sort by that Count column of the failures.

But this doesn't take into account that some jobs might run way more than others, and the failure count could be high while the percentage of jobs that failed could be very low.

So to take it to the next level and only see jobs that have not passed within 7 days, I think you would have to use custom JSON input in the visualization (click the Advanced link at the bottom of the aggregation).

I can't tell you exactly how to do your customer JSON input but I found one example here;

> [@Display concurrency in data on Kibana](https://discuss.elastic.co/t/display-concurrency-in-data-on-kibana/26006):
>
> I have fields with start date and duration (seconds) representing start and duration of a phone call. I would like to define concurrency (a number) when the same destination (also a field) is active within the same duration. That is if a ncall starts now for 30 seconds and another call to the same destination starts 15 seconds into the first call, concurrency should be 2 for the remaining 15 seconds. How do I define this in Kibana visualization as a line graph over time?

Hope this helps,  
Lee

---

_[View the full topic](https://discuss.elastic.co/t/how-to-create-a-kibana-visualization-to-show-jobs-failing-over-last-7-days/51217)._