I am obtaining all the data from a data source query based on a Universe (UNX).
Imagine you have a text field showing a total value.
That value is updated once or two times a day and it's never subtracted, always added.
So, for example, on day 1 you have a total of 100 and on that same day you could have a total of 102 and on the next day you will have a total of 107 and so on.
Is there a way to compare these two results and to use this result to build, for example, a KPI indicator with a percentage value?
I'm not finding a reasonable solution to create, with scripting, an "actual_value" variable that stores the actual value loaded from the data source and then, when this value changes, store it on an "old_value" variable and refresh the actual_value with the new one.
The objective is to compare "old_value" with "actual_value" and build the KPI percentage indicator.
Thank you in advance.