Comparing Present and Previous quarter images

[#1]

Hi All,

I have field with metric

1=yellow

2=red

3=green

the Expression is

=if(Field='Green','3',

if(Field='Red','1',

if(Field='Yellow','2')))

TEXT Color

=if(Field='3','qmem://<bundled>/BuiltIn/led_g.png',

if(Field='1','qmem://<bundled>/BuiltIn/led_r.png',

if(Field='2','qmem://<bundled>/BuiltIn/led_y.png')))

Result is

I want to Compare with Current data with previous data with colours

if Previous quarter is green and present quarter result is Red then should show (custom Image)..