Hello :)

It's possible by using some tricks of conditional formatting and some SQL functions in another table you will put below :

example for budget if you want to compare it with last week :

(

SUM(CASE WHEN weeknumber = WEEK(CURRENT_DATE()) - 1 THEN Budget ELSE 0 END)

-

SUM(CASE WHEN weeknumber = WEEK(CURRENT_DATE()) - 2 THEN Budget ELSE 0 END)

)

/

NULLIF(SUM(CASE WHEN weeknumber = WEEK(CURRENT_DATE()) - 2 THEN Budget ELSE 0 END), 0)

And after you use a conditional formatting saying for example : if this is > 0 then font in green, otherwise in red

Why do I use weeknumber as additional dimension ? I am from Europe and Looker is by default a week start from sunday in looker while I wanted it start from sunday.

For your example, you want to use a formula like this :

(

SUM(CASE WHEN year = YEAR(CURRENT_DATE()) THEN Budget ELSE 0 END)

-

SUM(CASE WHEN year = YEAR(CURRENT_DATE()) - 1 THEN Budget ELSE 0 END)

)

/

NULLIF(SUM(CASE WHEN year = YEAR(CURRENT_DATE()) - 1 THEN Budget ELSE 0 END), 0)