Hello Team,
Below is a script :
Color :
Load * Inline
[
Year1,Question,Value
2018,Score,88
2017,Score,86
2018,Unhappy,88
2017,Unhappy,89
];
In KPI i want to show difference of two years for Score and Dis based on qsVariable Extension where we have a dropdown for same.
The Colors logic is that if value of 2018 is greater than 2017 then value should be green else red [Only for Score]
For Unhappy it will be opposite , green for negative value and red for positive value.
In above case both should return green.
How to achieve it?
Thanks,
Arvind