Use Over Statement to get previous day value for KPI visual
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?