I have a requirment like Interval match in Object level, what i mean to say is; i have build an expression in text object to show Score on Dashboard. this resulted Score is link with another table which contains band/Grade.
this could be easily achivable using interval match function in script level but how does it possible on GUI level.
Reslut number : 69
Score Band : 50 55 60 70 80 90
0 1 2 3 4 5
Expected result should be 2 in a another text object.
there are nearly 3 KPIs for each Bases (bases and KPIs can grow in numbers) , it would be really difficult to create so many Variable to handle all bases with combination of KPI, KPI is the value which i want to display in text object. text object is a just an example, real requirment would be to display Health card in single Table.