# Colouring text result from query

**URL:** <https://discuss.elastic.co/t/colouring-text-result-from-query/272149>\
**Category:** Kibana\
**Tags:** canvas\
**Created:** [May 5, 2021, 8:57am UTC](https://discuss.elastic.co/t/colouring-text-result-from-query/272149 "2021-05-05T08:57:58Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![accateo](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/accateo/32/85332_2.png) [@accateo](https://discuss.elastic.co/u/accateo)\
**Post date:** [May 5, 2021, 8:57am UTC](https://discuss.elastic.co/t/colouring-text-result-from-query/272149/1 "2021-05-05T08:57:58Z")

</div>

Hi,  
I'm trying to color text that is result from a query:

```auto
filters
| essql 
  query="SELECT date + interval '2' hour as dateNew, DATEDIFF('minute',date, CURRENT_TIMESTAMP()) as diff FROM device_data_eggy ORDER BY date DESC LIMIT 1"
| mapColumn name="formatted_date" expression={getCell "dateNew" | formatdate format="DD/MM/YY HH:mm"}
| var_set "color" value={if condition={getCell column="diff" | lt 30} then="green" else="red"}
| markdown "{{#each rows}} {{formatted_date}} {{/each}}"
| render css=".canvasRenderEl p{
  font-family: 'Quicksand';
  color: \"" {var "color"} "\" ;
}"

```

but I have this error:

```auto
[render] > Unknown argument '_' passed to function 'render'

```

Why?  
Thanks

---

<div class="post-metadata">

**Author:** ![accateo](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/accateo/32/85332_2.png) [@accateo](https://discuss.elastic.co/u/accateo)\
**Post date:** [May 6, 2021, 11:05am UTC](https://discuss.elastic.co/t/colouring-text-result-from-query/272149/3 "2021-05-06T11:05:00Z")

</div>

```auto
filters
| essql 
  query="SELECT date + interval '2' hour as dateNew, DATEDIFF('minute',date, CURRENT_TIMESTAMP()) as diff FROM device_data_eggy ORDER BY date DESC LIMIT 1"
| var_set name="color" value={if condition={getCell column="diff" | lt 30} then="green" else="red"}
| mapColumn name="formatted_date" expression={getCell "dateNew" | formatdate format="DD/MM/YY HH:mm"}
| markdown "{{#each rows}} {{formatted_date}} {{/each}}"
| render 
  css={string ".canvasRenderEl p{
  font-family: 'Quicksand';
  color: " {var name="color"} ";
}"}

```

The error was the presence of \

---

<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:** [June 3, 2021, 11:05am UTC](https://discuss.elastic.co/t/colouring-text-result-from-query/272149/4 "2021-06-03T11:05:32Z")

</div>

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