Use Over Statement to get previous day value for KPI visual

Hi All,

I was hoping someone could help me with what could be a very simple question. I've just downloaded the latest version Spotfire 7.6 and i'm looking at the KPI visualisation.

I've attached a simple example where i have a small data set of daily values. The objective is to show the Plant Utilisation from date chosen from the drop down menu in the text area. What i need is support on the comparison value which needs to be the previous days value.

I think that this can be achieved using an over statement but i cant seem to get my head around the over statment to show the previous days value. Can anyone help?




Binary Data test_calculations_support.dxp146.2 KB

(3) Answers