How to create a conditional KPI to change the colors

[sims]

Hi Everyone 

I want help and thanks in advance 

I have data which shows customers balances in a table below. I want to create a conditional KPI which change colors by checking if sum(balance) current is greater or less than the previous sum(balance) instance.

ID	Date&Time	Balance
MN001	2019-12-14 18:15:32.4967333 +02:00	20
MN002	2019-12-14 18:15:32.4967333 +02:00	15
MN003	2019-12-16 09:28:09.3790911 +02:00	60
MN004	2019-12-16 14:16:36.2906864 +02:00	10
MN005	2019-12-16 15:33:47.1230789 +02:00	98
MN006	2019-12-17 15:58:04.0504066 +02:00	200
MN007	2019-12-17 18:21:00.4941654 +02:00	600
MN008	2019-12-17 18:21:00.4941654 +02:00	800
MN009	2019-12-17 20:26:02.7718598 +02:00	700
MN010	2019-12-18 07:43:45.7908600 +02:00	5
MN011	2019-12-18 20:28:36.4884641 +02:00	360
MN012	2019-12-18 20:28:36.4884641 +02:00	450
MN013	2019-12-19 07:23:50.5477063 +02:00	10
MN014	2019-12-19 17:12:30.7128309 +02:00	978

[martinpohl]

the colour you can define is depending on the expression (balance) not on the compare of a second expression (balance-prev. balance)

Maybe a table chart with indicator helps?

Regards

[sims]

Yes I know. They are two colors involved red and green. So if the current balance is greater than the previous the it should be green else red. Remember the balance can increase or decrease.

[abhijitnalekar]

Hi @sims ,

Are you looking for something like this?

Create new filed at script level as  previous(Balance) as PrevBalance

and use below formula in the column property background color expression 

if(Balance>PrevBalance,green(),red())