# Conditional Coloring on Pie Chart on Canvas

**URL:** https://discuss.elastic.co/t/conditional-coloring-on-pie-chart-on-canvas/279358
**Category:** Kibana
**Tags:** canvas
**Created:** [July 22, 2021, 8:42am UTC](https://discuss.elastic.co/t/conditional-coloring-on-pie-chart-on-canvas/279358 "2021-07-22T08:42:48Z")
**Posts on this page:** 5
**Page:** 1

<div class="post-metadata">

### Author: ![Mayank\_Malhotra](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/mayank_malhotra/32/91991_2.png) [@Mayank\_Malhotra](https://discuss.elastic.co/u/Mayank_Malhotra)
#### Post date: [July 22, 2021, 8:42am UTC](https://discuss.elastic.co/t/conditional-coloring-on-pie-chart-on-canvas/279358/1 "2021-07-22T08:42:48Z")

</div>

Hi,  
I have created a Pie Chart on canvas which consists a field severity which as two values one is ERROR and the other is WARNING. I want to show the part of WARNING in pie-chart as orange and ERROR as red. I Used below script in expression editor but it's not stable sometimes ERROR's part get Orange and WARNING's part RED and vice versa.  
filters  
| essql  
query="SELECT severity,uuId FROM "(Index\_pattern)" WHERE alarmRaisedTime \> CURRENT\_TIMESTAMP() - INTERVAL 1 DAYS AND host\_information.Site = '#####' AND alarmType \<\> '#####'"  
| pointseries color="severity" size="unique(uuId)"  
| pie palette={palette "#feb24c" "#f03b20" gradient=false} labels=false legend="ne"  
| render css=".canvasRenderEl{

}"

If anyone has some solution how can I apply condition's on coloring of pie chart it would be helpful.

Thanks in Advance

---

<div class="post-metadata">

### Author: ![poff](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/poff/32/81795_2.png) [@poff](https://discuss.elastic.co/u/poff)
#### Post date: [July 22, 2021, 7:10pm UTC](https://discuss.elastic.co/t/conditional-coloring-on-pie-chart-on-canvas/279358/2 "2021-07-22T19:10:03Z")

</div>

Hey there! I think what you're looking for is series styling based on label in your data. Check out the post here: [Pie chart colors change](https://discuss.elastic.co/t/pie-chart-colors-change/184036)

---

<div class="post-metadata">

### Author: ![Mayank\_Malhotra](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/mayank_malhotra/32/91991_2.png) [@Mayank\_Malhotra](https://discuss.elastic.co/u/Mayank_Malhotra)
#### Post date: [July 23, 2021, 5:44am UTC](https://discuss.elastic.co/t/conditional-coloring-on-pie-chart-on-canvas/279358/3 "2021-07-23T05:44:33Z")

</div>

Thanks Poff it worked 🙂 .

---

<div class="post-metadata">

### Author: ![poff](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/poff/32/81795_2.png) [@poff](https://discuss.elastic.co/u/poff)
#### Post date: [July 24, 2021, 3:29pm UTC](https://discuss.elastic.co/t/conditional-coloring-on-pie-chart-on-canvas/279358/4 "2021-07-24T15:29:19Z")

</div>

Excellent!

---

<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: [August 21, 2021, 3:29pm UTC](https://discuss.elastic.co/t/conditional-coloring-on-pie-chart-on-canvas/279358/5 "2021-08-21T15:29:36Z")

</div>

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