# Help visualizing simple data in a line chart

**URL:** <https://discuss.elastic.co/t/help-visualizing-simple-data-in-a-line-chart/27064>\
**Category:** Kibana\
**Created:** [August 7, 2015, 8:01pm UTC](https://discuss.elastic.co/t/help-visualizing-simple-data-in-a-line-chart/27064 "2015-08-07T20:01:34Z")\
**Posts on this page:** 9\
**Page:** 1

<div class="post-metadata">

**Author:** ![jjdepaul](https://avatars.discourse-cdn.com/v4/letter/j/e0b2c6/32.png) [@jjdepaul](https://discuss.elastic.co/u/jjdepaul)\
**Post date:** [August 7, 2015, 8:01pm UTC](https://discuss.elastic.co/t/help-visualizing-simple-data-in-a-line-chart/27064/1 "2015-08-07T20:01:34Z")

</div>

I'm a novice to Kibana. I have just installed the product and I can access it from my browser. I have registered my index: sprint and I can see some of the data in the Discover tab in Kibana (4.1.1-Win).

The data that I have in ElasticSearch captures specific events with just two attributes: **status** and **timstamp** (tslice) of the event - that's all.

I would like to create a simple visualization to distinguish the Success runs from Failure runs that this data captures across the time period.

I'd like to setup a simple timeline and graphically show the Successes vs Failures over time.

Could someone please help point me in the right direction.

Here is the sample output data:

```
}
      "hits" : {
        "total" : 5,
        "max_score" : 1.0,
        "hits" : [ {
          "_index" : "sprint",
          "_type" : "sysout",
          "_id" : "AU8EcFUwErJTJM_bP4rH",
          "_score" : 1.0,
          "_source":{"message":".....","tslice":"8/01/15 18:50:59:616","status":"failure"}
        }, {
          "_index" : "sprint",
          "_type" : "sysout",
          "_id" : "AU8EcFUwErJTJM_bP4rI",
          "_score" : 1.0,
          "_source":{"message":"....t","tslice":"8/02/15 18:50:59:616","status":"success"}
        }, {
          "_index" : "sprint",
          "_type" : "sysout",
          "_id" : "AU8DyhBIErJTJM_bP4rF",
          "_score" : 1.0,
          "_source":{"message":".....","tslice":"7/30/15 18:50:59:616","status":"success"}
        }, {
          "_index" : "sprint",
          "_type" : "sysout",
          "_id" : "AU8EcFUwErJTJM_bP4rJ",
          "_score" : 1.0,
          "_source":{"message":"...t","tslice":"8/03/15 18:50:59:616","status":"success"}
        }, {
          "_index" : "sprint",
          "_type" : "sysout",
          "_id" : "AU8EcFLWErJTJM_bP4rG",
          "_score" : 1.0,
          "_source":{"message":".....","tslice":"7/31/15 18:50:59:616","status":"success"}
        } ]
      }
    }
```

---

<div class="post-metadata">

**Author:** ![PatrickKik](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/patrickkik/32/619_2.png) [@PatrickKik](https://discuss.elastic.co/u/PatrickKik)\
**Post date:** [August 10, 2015, 5:10am UTC](https://discuss.elastic.co/t/help-visualizing-simple-data-in-a-line-chart/27064/2 "2015-08-10T05:10:59Z")

</div>

One direction might be to take a Line Chart.Visualization:

 ![](https://us1.discourse-cdn.com/elastic/original/2X/b/b964acdafdecda7d928e9f0d6981132039cbf4d0.png)

---

<div class="post-metadata">

**Author:** ![jjdepaul](https://avatars.discourse-cdn.com/v4/letter/j/e0b2c6/32.png) [@jjdepaul](https://discuss.elastic.co/u/jjdepaul)\
**Post date:** [August 10, 2015, 7:01pm UTC](https://discuss.elastic.co/t/help-visualizing-simple-data-in-a-line-chart/27064/3 "2015-08-10T19:01:08Z")

</div>

I have tried creating a Line chart and Vertical Bar chart. I think Vertical Bar chart is what I need, but I can't get it to show me the graph that I'm after.

I'm including a pic of what I want it to look like:  
I want it to be Hourly showing results in 24 hr intervals. I want it to show a different color based on the status (success vs failure). I want it to show three states in each 24hr period: success, failure, no data. Here is a sample of what it would look like. The green=success, the red=failure, and the empty time slot means there was no data for that hour.

![](https://us1.discourse-cdn.com/elastic/original/2X/b/bbe5df9e7edea3398003da22b27d8352206e76d8.jpg)

---

<div class="post-metadata">

**Author:** ![jjdepaul](https://avatars.discourse-cdn.com/v4/letter/j/e0b2c6/32.png) [@jjdepaul](https://discuss.elastic.co/u/jjdepaul)\
**Post date:** [August 11, 2015, 2:59am UTC](https://discuss.elastic.co/t/help-visualizing-simple-data-in-a-line-chart/27064/4 "2015-08-11T02:59:35Z")

</div>

Let me ask a specific question: in the Vertical Bar Chart configuration, is there a way to control the color of the line bar conditionally?!

---

<div class="post-metadata">

**Author:** ![jjdepaul](https://avatars.discourse-cdn.com/v4/letter/j/e0b2c6/32.png) [@jjdepaul](https://discuss.elastic.co/u/jjdepaul)\
**Post date:** [August 11, 2015, 3:23pm UTC](https://discuss.elastic.co/t/help-visualizing-simple-data-in-a-line-chart/27064/5 "2015-08-11T15:23:12Z")

</div>

Anybody have any insight on this, please?! I've scoured the documentation on this and there doesn't appear to be a way to condition the color of the vertical bars. How can I achieve the highlights that I need?

---

<div class="post-metadata">

**Author:** ![jjdepaul](https://avatars.discourse-cdn.com/v4/letter/j/e0b2c6/32.png) [@jjdepaul](https://discuss.elastic.co/u/jjdepaul)\
**Post date:** [August 11, 2015, 11:00pm UTC](https://discuss.elastic.co/t/help-visualizing-simple-data-in-a-line-chart/27064/6 "2015-08-11T23:00:03Z")

</div>

Is there a way to extend this widget to decorate some of the functionality that it has? Somebody, throw me a bone here...

---

<div class="post-metadata">

**Author:** ![tbragin](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/tbragin/32/45166_2.png) [@tbragin](https://discuss.elastic.co/u/tbragin)\
**Post date:** [August 12, 2015, 12:28am UTC](https://discuss.elastic.co/t/help-visualizing-simple-data-in-a-line-chart/27064/7 "2015-08-12T00:28:18Z")

</div>

I don't think the exact visualization you're looking for is possible. Why not just split bars by success vs failure over time?

 ![](https://us1.discourse-cdn.com/elastic/original/2X/0/04609e1b07b5564997c3e8dde6215e0a3501041a.png)

---

<div class="post-metadata">

**Author:** ![jjdepaul](https://avatars.discourse-cdn.com/v4/letter/j/e0b2c6/32.png) [@jjdepaul](https://discuss.elastic.co/u/jjdepaul)\
**Post date:** [August 13, 2015, 7:20pm UTC](https://discuss.elastic.co/t/help-visualizing-simple-data-in-a-line-chart/27064/8 "2015-08-13T19:20:15Z")

</div>

Thanks, Tanya -

I was able to implement that visualization like you recommended. It works ok. I need to drill down to hourly display to see what I need to see, but I can get to what I need to it.

Thank you for the suggestion.

---

<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 6, 2017, 2:14pm UTC](https://discuss.elastic.co/t/help-visualizing-simple-data-in-a-line-chart/27064/9 "2017-07-06T14:14:50Z")

</div>


