# \[Easy\] Pie chart of 2 different fields

**URL:** <https://discuss.elastic.co/t/easy-pie-chart-of-2-different-fields/212454>\
**Category:** Kibana\
**Created:** [December 19, 2019, 9:06am UTC](https://discuss.elastic.co/t/easy-pie-chart-of-2-different-fields/212454 "2019-12-19T09:06:00Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![Kevin\_Csuka](https://avatars.discourse-cdn.com/v4/letter/k/7feea3/32.png) [@Kevin\_Csuka](https://discuss.elastic.co/u/Kevin_Csuka)\
**Post date:** [December 19, 2019, 9:06am UTC](https://discuss.elastic.co/t/easy-pie-chart-of-2-different-fields/212454/1 "2019-12-19T09:06:00Z")

</div>

I'm clicking around endlessly without any hope. Googling around without any success.

I have 2 fields in Elasticsearch with a single value, see:

[[Album] Imgur ![](https://us1.discourse-cdn.com/elastic/original/3X/e/d/ed8e78c7ffb9c81fef1b118fee33c6794018fa7d.jpeg "Imgur") ](https://imgur.com/a/QqRJdrM)

How can I make a pie-chart so that I see like this:

[[Album] Imgur ![](https://us1.discourse-cdn.com/elastic/original/3X/4/1/41d5973dba2477b60c9d7e00ae3547667e0e7a93.jpeg "Imgur") ](https://imgur.com/a/7NCkZsF)

Note that the fields are converted to 'float'.

---

<div class="post-metadata">

**Author:** ![Kevin\_Csuka](https://avatars.discourse-cdn.com/v4/letter/k/7feea3/32.png) [@Kevin\_Csuka](https://discuss.elastic.co/u/Kevin_Csuka)\
**Post date:** [December 20, 2019, 10:07am UTC](https://discuss.elastic.co/t/easy-pie-chart-of-2-different-fields/212454/2 "2019-12-20T10:07:19Z")

</div>

Anyone?

---

<div class="post-metadata">

**Author:** ![Marius\_Dragomir](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/marius_dragomir/32/42087_2.png) [@Marius\_Dragomir](https://discuss.elastic.co/u/Marius_Dragomir)\
**Post date:** [December 20, 2019, 1:30pm UTC](https://discuss.elastic.co/t/easy-pie-chart-of-2-different-fields/212454/3 "2019-12-20T13:30:39Z")

</div>

What do you want to display in that Pie Chart? The ratio of that fields? Data doesn't really work like that in Elasticsearch normally. But with Canvas you can probably display that ratio in a Pie Chart.

> **[Intro to Canvas: A new way to tell visual stories in Kibana](https://www.elastic.co/webinars/intro-to-canvas-a-new-way-to-tell-visual-stories-in-kibana)**
>
> If you want to customize your visualizations beyond Kibana dashboards, Canvas is the tool for you. Play with color palettes, add your own CSS elements, drag and drop assets — and turn your presentations and reports into dynamic works of art.

---

<div class="post-metadata">

**Author:** ![Kevin\_Csuka](https://avatars.discourse-cdn.com/v4/letter/k/7feea3/32.png) [@Kevin\_Csuka](https://discuss.elastic.co/u/Kevin_Csuka)\
**Post date:** [December 23, 2019, 9:35am UTC](https://discuss.elastic.co/t/easy-pie-chart-of-2-different-fields/212454/4 "2019-12-23T09:35:45Z")

</div>

> [@Marius\_Dragomir](#):
>
> What do you want to display in that Pie Chart? The ratio of that fields? Data doesn't really work like that in Elasticsearch normally. But with Canvas you can probably display that ratio in a Pie Chart.

Canvas sounds like a workaround. I'd like to create a pie-chart as shown in my first post.  
This is a sample how I send data to Elasticsearch:

.csv input:

```
# epoch, ebsAvgPrice, vioAvgPrice
1576425930,0.0718,0.0127

```

My Logstash config:

```
filter {
  csv {
        separator => ","
        columns => ["timestamp","ebsAvgPrice","vioAvgPrice"]
        convert => { "timestamp" => "integer" }
        convert => { "ebsAvgPrice" => "float" }
        convert => { "vioAvgPrice" => "float" }

```

I assume this isn't the way how I should process the data.

What is the way to go? @Marius_Dragomir

---

<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:** [January 20, 2020, 9:35am UTC](https://discuss.elastic.co/t/easy-pie-chart-of-2-different-fields/212454/5 "2020-01-20T09:35:46Z")

</div>

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