Is date from your table impact the color? or only at variable that change the color?
If you want to trigger user to pick date from your variable and choose location so the color show up.
I change your background color at simplekpi into this one.
=if(vFlexDate<>null() and Location='A2', GREEN(), WHITE())
Hope this helps
Basicaly here is what I want. When user trigger a date (meaning variable vFlexDate is set to a value) I want to highlight the location by changing the background of A1 or A2 depending on where my selected type was located base on the data set in my App.
Let me know if it's clear enough
I'm still not understand what you wanna do, what i got like this
1. You have variable to trigger a date
2. You have simple KPI which is you want it can change the background
1. What condition trigger to change the background color?
2. is it simple kpi trigger to change background color on table?
But rather than you use variable, you can use the script to create a new field change current date as today, and then you can use new field as your condition.
I think it's easier rather than using variable.