# Color change based on field value instead of count

**URL:** https://discuss.elastic.co/t/color-change-based-on-field-value-instead-of-count/323117
**Category:** Kibana
**Tags:** lens
**Created:** [January 13, 2023, 10:39am UTC](https://discuss.elastic.co/t/color-change-based-on-field-value-instead-of-count/323117 "2023-01-13T10:39:31Z")
**Posts on this page:** 3
**Page:** 1

<div class="post-metadata">

### Author: ![alytkowski](https://avatars.discourse-cdn.com/v4/letter/a/cc9497/32.png) [@alytkowski](https://discuss.elastic.co/u/alytkowski)
#### Post date: [January 13, 2023, 10:39am UTC](https://discuss.elastic.co/t/color-change-based-on-field-value-instead-of-count/323117/1 "2023-01-13T10:39:31Z")

</div>

I'm trying to create a visualization, which will allow me to show my data from a community created Beats - Processbeat. It's a monitoring of processes with statuses like "RUNNING" or "STOPPED".  
Now to the point, below is an example of a Waffle:

 ![image](https://us1.discourse-cdn.com/elastic/original/3X/6/1/614e1eb5e5b0147ddde24ec889a07201cd2cb79f.png)

And it would be perfectly fine, if only I could choose 2 colors - Green - for field "STATUS"="RUNNING" and Red for field "STATUS"="STOPPED".  
Instead Kibana automatically assigns colors.

Is there a way to fix this in the newest version of Kibana, or do I need to create an issue on Github for future release?

---

<div class="post-metadata">

### Author: ![Marco\_Liberati](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/marco_liberati/32/82953_2.png) [@Marco\_Liberati](https://discuss.elastic.co/u/Marco_Liberati)
#### Post date: [January 13, 2023, 3:27pm UTC](https://discuss.elastic.co/t/color-change-based-on-field-value-instead-of-count/323117/2 "2023-01-13T15:27:57Z")

</div>

Hi @alytkowski

there's this feature request which will provide a way to associate a color to a "term" or category: [[Lens] Support categorical coloring by name · Issue #101942 · elastic/kibana · GitHub](https://github.com/elastic/kibana/issues/101942) .

Right now there's some sort of workaround to color terms with a specific color, which is remapping the field values to a number via a runtime field (i.e. RUNNING: 1, STOPPED: 0 ).  
The only problem is that you need a `Last value` operation to pick only the latest status in the time range, and that won't support the palette coloring in Lens yet.

---

<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: [February 10, 2023, 3:28pm UTC](https://discuss.elastic.co/t/color-change-based-on-field-value-instead-of-count/323117/3 "2023-02-10T15:28:10Z")

</div>

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