1.29kviews

Use Over Statement to get previous day value for KPI visual

#KPIs

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?

Thanks,

John

Attachments

Attachment	Size
test_calculations_support.dxp	146.2 KB

Jul 26, 2016 - 3:11am

jc2016

Flag as Inappropriate

+ Add a Comment

(3) Answers

To do this create a calculated column with the value you want to use for comparison. For example:

Sum([Total_Amount_Produced]) OVER Previous([Date]) as [Previous Day Total]

Then in your KPI Settings > Values > Comparative value, you can use an expression which references that value like:

Sum([Previous Day Total]) as [Previous Day Total]

Or as a delta %:

((Sum([Total_Amount_Produced] / [Production_Hrs]) / Sum([Previous Day Total]))) - 1

I would think this should be possible to do with an OVER function in the Comparative Value expression directly, but the scope of each tile is limited to each tile only (even using OVER All(...)). I would submit that as an enhancement request directly in the new Spotfire Ideas Portal that was developed by our Product Management team: