Skip to Content
0
Former Member
Apr 06, 2016 at 11:15 AM

Is it possible to compare old and new values from the same data source?

178 Views

Hi everyone,

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.

Any ideias?

Thank you in advance.

JA