# Help Creating a Visualization

**URL:** https://discuss.elastic.co/t/help-creating-a-visualization/218416
**Category:** Kibana
**Created:** [February 7, 2020, 9:16pm UTC](https://discuss.elastic.co/t/help-creating-a-visualization/218416 "2020-02-07T21:16:48Z")
**Posts on this page:** 5
**Page:** 1

<div class="post-metadata">

### Author: ![CommanderTso](https://avatars.discourse-cdn.com/v4/letter/c/9de0a6/32.png) [@CommanderTso](https://discuss.elastic.co/u/CommanderTso)
#### Post date: [February 7, 2020, 9:16pm UTC](https://discuss.elastic.co/t/help-creating-a-visualization/218416/1 "2020-02-07T21:16:48Z")

</div>

Hi folks,

I'm working my way through learning Kibana, but was hoping someone could give me a leg-up on a visualization I've been asked to create in the short term.

I have an index of filebeat documents harvested from /var/log/messages on a Lustre storage system. For the records in there that I want to visualize, each will have a value for error.type and error.additional\_occurances. The second field there represents the number of additional identical messages that Lustre squashed down.

I'd like to create a visualization that will show, overtime, the occurrances of each error.type and augment its magnitude on the visualization by the number of error.additional\_occurances. For example, if I had, say an error of type "bulk READ error" with an additional\_occurances of 400, the magnitude for that error at that point in time would be 400 (see note at bottom).

I'm open to bucketing this stuff however is helpful, and open to building it with Timeline, Visual Builder - whatever works. Any pointers you folks might have for me would be very welcome.

Thanks!

Note: To be exact, it would be 401 (the record itself plus the additional\_occurances), but I don't need to get hung up on that.

---

<div class="post-metadata">

### Author: ![CommanderTso](https://avatars.discourse-cdn.com/v4/letter/c/9de0a6/32.png) [@CommanderTso](https://discuss.elastic.co/u/CommanderTso)
#### Post date: [February 7, 2020, 9:30pm UTC](https://discuss.elastic.co/t/help-creating-a-visualization/218416/2 "2020-02-07T21:30:24Z")

</div>

Playing with it more, I tried:

`.es(index=filebeat-storage*,split=error.type:10, metric=sum:error.additional_occurances)`

My concern here is that I'm pretty sure I'm dropping events that don't have a value for additional\_occurances, which won't be present if my grok parser didn't find any corresponding value in the log entry.

---

<div class="post-metadata">

### Author: ![flash1293](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/flash1293/32/41227_2.png) [@flash1293](https://discuss.elastic.co/u/flash1293)
#### Post date: [February 11, 2020, 11:51am UTC](https://discuss.elastic.co/t/help-creating-a-visualization/218416/3 "2020-02-11T11:51:57Z")

</div>

Hi @CommanderTso,

that looks pretty good already. You can add a static value of one (the implicit original error that didn't get squashed) to each value like this:

```auto
.es(index=filebeat-storage*,split=error.type:10, metric=sum:error.additional_occurances).add(.static(1))

```

This should make sure you are not dropping empty buckets

---

<div class="post-metadata">

### Author: ![CommanderTso](https://avatars.discourse-cdn.com/v4/letter/c/9de0a6/32.png) [@CommanderTso](https://discuss.elastic.co/u/CommanderTso)
#### Post date: [February 11, 2020, 2:15pm UTC](https://discuss.elastic.co/t/help-creating-a-visualization/218416/4 "2020-02-11T14:15:00Z")

</div>

Awesome - thanks! I'm also working through the Kibana on-demand course, and the introduction of aggregations fills a big hole in my understanding of how the Visualizations can work.

---

<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: [March 10, 2020, 2:15pm UTC](https://discuss.elastic.co/t/help-creating-a-visualization/218416/5 "2020-03-10T14:15:15Z")

</div>

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