# How to show kibana histogramme with two files values

**URL:** https://discuss.elastic.co/t/how-to-show-kibana-histogramme-with-two-files-values/129631
**Category:** Kibana
**Created:** [April 26, 2018, 9:59am UTC](https://discuss.elastic.co/t/how-to-show-kibana-histogramme-with-two-files-values/129631 "2018-04-26T09:59:36Z")
**Posts on this page:** 3
**Page:** 1

<div class="post-metadata">

### Author: ![ali1](https://avatars.discourse-cdn.com/v4/letter/a/76d3ee/32.png) [@ali1](https://discuss.elastic.co/u/ali1)
#### Post date: [April 26, 2018, 9:59am UTC](https://discuss.elastic.co/t/how-to-show-kibana-histogramme-with-two-files-values/129631/1 "2018-04-26T09:59:37Z")

</div>

Hello ,

i have the following index with these values

 ![tableau_index](https://us1.discourse-cdn.com/elastic/original/3X/6/0/60cea0b0e324a649362250a6f1b93ec08634ff64.png)

and i want to show a histogramme like this :  
1- X-Axis contains the value of the Code filed.  
2 - Y-Axis contains the value of the Amount filed.

can you please show me how to acheive this i'm new user of kibana dashboard

---

<div class="post-metadata">

### Author: ![jbudz](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/jbudz/32/45922_2.png) [@jbudz](https://discuss.elastic.co/u/jbudz)
#### Post date: [April 26, 2018, 8:57pm UTC](https://discuss.elastic.co/t/how-to-show-kibana-histogramme-with-two-files-values/129631/2 "2018-04-26T20:57:50Z")

</div>

Hey Ali,

Kibana's visualization tooling works by grouping sets of data together. Typically it won't plot flat x and y values. In this limited data set we can make it work. Scatter plots are difficult with large amounts of data so we have to group it together

Under visualize, select bar chart and the metric aggregation will be `max` on 'Amount' and the bucket aggregation will be `terms` on `Code`. In this case Kibana will make buckets of data (each code) and then performs some math on that bucket. If there are multiple rows with the same `Code` in this case it would take the largest Amount.

---

<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: [May 24, 2018, 8:58pm UTC](https://discuss.elastic.co/t/how-to-show-kibana-histogramme-with-two-files-values/129631/3 "2018-05-24T20:58:03Z")

</div>

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