# Conditional colouring using kibana canvas expression editor

**URL:** https://discuss.elastic.co/t/conditional-colouring-using-kibana-canvas-expression-editor/177929
**Category:** Kibana
**Tags:** canvas
**Created:** [April 23, 2019, 3:42am UTC](https://discuss.elastic.co/t/conditional-colouring-using-kibana-canvas-expression-editor/177929 "2019-04-23T03:42:57Z")
**Posts on this page:** 1
**Showing post:** 5

<div class="post-metadata">

### Author: ![Catherine\_Liu](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/catherine_liu/32/34294_2.png) [@Catherine\_Liu](https://discuss.elastic.co/u/Catherine_Liu)
#### Post date: [May 9, 2019, 7:48pm UTC](https://discuss.elastic.co/t/conditional-colouring-using-kibana-canvas-expression-editor/177929/5 "2019-05-09T19:48:24Z")

</div>

> [@ksunil](#):
>
> filters  
> | essql  
> query="SELECT "system.load.1" AS LOAD FROM "metricbeat\*" WHERE metricset.module = 'system' AND metricset.name = 'load' AND beat.hostname LIKE 'XXXXXX%' AND "@timestamp" \<= NOW () LIMIT 1"

Try this expression and see if the element looks right:

```auto
filters
| essql
query="SELECT "system.load.1" AS LOAD FROM "metricbeat*" WHERE metricset.module = 'system' AND metricset.name = 'load' AND beat.hostname LIKE 'XXXXXX%' AND "@timestamp" <= NOW () LIMIT 1"
| metric LOAD 
  metricFont={font size=48 family="'Open Sans', Helvetica, Arial, sans-serif" color={if {lt 10} then="red" else="green"} align="center" lHeight=48} 
  labelFont={font size=14 family="'Open Sans', Helvetica, Arial, sans-serif" color="#000000" align="center"}
| render

```

---

_[View the full topic](https://discuss.elastic.co/t/conditional-colouring-using-kibana-canvas-expression-editor/177929)._