# Conditional colouring of values in a column in a data table **URL:** \ **Category:** Kibana\ **Tags:** canvas\ **Created:** [August 12, 2020, 9:38am UTC](https://discuss.elastic.co/t/conditional-colouring-of-values-in-a-column-in-a-data-table/244693 "2020-08-12T09:38:42Z")\ **Posts on this page:** 6\ **Page:** 1
**Author:** ![silasr](https://avatars.discourse-cdn.com/v4/letter/s/76d3ee/32.png) [@silasr](https://discuss.elastic.co/u/silasr)\ **Post date:** [August 12, 2020, 9:38am UTC](https://discuss.elastic.co/t/conditional-colouring-of-values-in-a-column-in-a-data-table/244693/1 "2020-08-12T09:38:42Z")
Hi everyone. I'm trying to do some possibly advanced conditional statement for columns in a data table. Ideally, I would like to change the color of a string, based on the value of another field in the same document. I'm not sure how to approach it in expression editor, but a regular if statement would look something like: ```auto if ram_usage gt 10: then service font color="red" else service font color="green" ``` Wondering if this is possible with the expression editor, or if anyone has encountered a similar challenge and what their solution was. ---
**Author:** ![flash1293](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/flash1293/32/41227_2.png) [@flash1293](https://discuss.elastic.co/u/flash1293)\ **Post date:** [August 12, 2020, 9:44am UTC](https://discuss.elastic.co/t/conditional-colouring-of-values-in-a-column-in-a-data-table/244693/2 "2020-08-12T09:44:30Z")
You can't conditionally style table cells in Canvas yet - this is the issue tracking this request: [https://github.com/elastic/kibana/issues/27700](https://github.com/elastic/kibana/issues/27700) To a certain degree this is possible in a TSVB visualization which you can embed in a canvas, but it can only work on aggregated time series data, so I'm not sure whether it's a good option for you. ---
**Author:** ![silasr](https://avatars.discourse-cdn.com/v4/letter/s/76d3ee/32.png) [@silasr](https://discuss.elastic.co/u/silasr)\ **Post date:** [August 12, 2020, 9:55am UTC](https://discuss.elastic.co/t/conditional-colouring-of-values-in-a-column-in-a-data-table/244693/4 "2020-08-12T09:55:29Z")
Can you give an example? I don't fully understand what aggregated time series data means. ---
**Author:** ![flash1293](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/flash1293/32/41227_2.png) [@flash1293](https://discuss.elastic.co/u/flash1293)\ **Post date:** [August 12, 2020, 10:02am UTC](https://discuss.elastic.co/t/conditional-colouring-of-values-in-a-column-in-a-data-table/244693/5 "2020-08-12T10:02:50Z")
You can check out the capabilities of TSVB here (also talks about the table visualization): [https://www.elastic.co/guide/en/kibana/current/TSVB.html](https://www.elastic.co/guide/en/kibana/current/TSVB.html) Aggregatated time series data means you can't look at individual documents, but just at aggregated values over time, e.g. the average a field for all documents within a certain time bucket. ---
**Author:** ![silasr](https://avatars.discourse-cdn.com/v4/letter/s/76d3ee/32.png) [@silasr](https://discuss.elastic.co/u/silasr)\ **Post date:** [August 12, 2020, 10:10am UTC](https://discuss.elastic.co/t/conditional-colouring-of-values-in-a-column-in-a-data-table/244693/6 "2020-08-12T10:10:30Z")
Okay I see, thank you. ---
**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\ **Post date:** [September 9, 2020, 10:10am UTC](https://discuss.elastic.co/t/conditional-colouring-of-values-in-a-column-in-a-data-table/244693/7 "2020-09-09T10:10:34Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.