How to apply conditional threshold on a table

1

Hi,
I have a table want to apply threshold on con column t2 based on custom condition i.e.
if value of t2 > t3 then the t2 column value should be changed to red, which means the value 85 and 110 should be highlighted with red color.
if value of t2 < t4 then the t2 column value should be changed to orange, which means the value 25 should be highlighted with orange color

table snapshot attached for quick reference.
Is it possible to do so? Any help would be highly appreciated!

image
image1807×506 22.1 KB

2

I am trying to do the same thing. Any resolution for this question???

3

config from query transformation

image
image831×683 38.7 KB

along with

image
image468×527 25.4 KB

but this will require something like this in your datasource query (this is a sample)

with src
as
(

  select 'test_14' as t1, 25 as t2, 80 as t3, 35 t4 union
  select 'test_11' as t1, 85 as t2, 80 as t3, 40 t4
)
select *,
  case when t2 > t3 then '#FF0000'
   when t2 < t4 then '#FFA500'
  end  Color
 from src