# In a metric visualization change the color mode based on formula

**URL:** <https://discuss.elastic.co/t/in-a-metric-visualization-change-the-color-mode-based-on-formula/350928>\
**Category:** Kibana\
**Tags:** lens\
**Created:** [January 12, 2024, 10:23am UTC](https://discuss.elastic.co/t/in-a-metric-visualization-change-the-color-mode-based-on-formula/350928 "2024-01-12T10:23:06Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![SpicyS](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/spicys/32/125743_2.png) [@SpicyS](https://discuss.elastic.co/u/SpicyS)\
**Post date:** [January 12, 2024, 10:23am UTC](https://discuss.elastic.co/t/in-a-metric-visualization-change-the-color-mode-based-on-formula/350928/1 "2024-01-12T10:23:06Z")

</div>

Hello,

I'm building a dashboard and now I want to make a lens metric with average time per costomer. Now this isn't difficult but in the color mode I want it to change color based on a formula.

So when the current average is higher then 5\* the average in the past week, I want to change to red.

Currently it is limited to a pre defined value (also in TSVB)

Can someone help me with this question? Maybe i need a custom formula?

---

<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 12, 2024, 11:29am UTC](https://discuss.elastic.co/t/in-a-metric-visualization-change-the-color-mode-based-on-formula/350928/2 "2024-01-12T11:29:19Z")

</div>

Hi @SpicyS

it sounds like you're looking to color the metric chart by a distinct formula that the one used to compute. That is not possible in Lens.

I think we have an enhancement request for that here you can track: [[Lens] Separate color dimension for all chart types · Issue #95556 · elastic/kibana · GitHub](https://github.com/elastic/kibana/issues/95556)

---

<div class="post-metadata">

**Author:** ![SpicyS](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/spicys/32/125743_2.png) [@SpicyS](https://discuss.elastic.co/u/SpicyS)\
**Post date:** [January 12, 2024, 12:17pm UTC](https://discuss.elastic.co/t/in-a-metric-visualization-change-the-color-mode-based-on-formula/350928/3 "2024-01-12T12:17:12Z")

</div>

Hey @Marco_Liberati

Thank you for the quick response, to bad it is not possible yet. Do you think it may be possible in Vega then? Or is it better to create alerts based on this question?

---

<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 23, 2024, 8:58am UTC](https://discuss.elastic.co/t/in-a-metric-visualization-change-the-color-mode-based-on-formula/350928/4 "2024-01-23T08:58:54Z")

</div>

I think that would be possible in Vega.

---

<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 20, 2024, 8:59am UTC](https://discuss.elastic.co/t/in-a-metric-visualization-change-the-color-mode-based-on-formula/350928/5 "2024-02-20T08:59:46Z")

</div>

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