You can set up KPIs to automatically calculate their actual values and thresholds from other values in Spider Impact. For more information about what Spider Impact actually does when it's calculating a KPI value, please see the Exploring How a KPI is Calculated article.
Calculated KPI Details
Let's start things off with a simple example. We're going to create a calculated KPI called Total Revenue that is the sum of Product Revenue, Training Revenue, and Book Revenue.
There's a lot going on in the Edit tab, so we'll look at each configuration option one at a time.
- We've changed the KPI's actual value from Manual to Calculated.
- The Goal and Red Flag thresholds are still manually updated. As you can see, we've typed in default values for both.
- We can choose a Manual Aggregation Type like Sum or Average. This only applies to the threshold values because they are manually updated.
- We can choose a Calculated Aggregation Type. The options here are Sum (recommended) and Use Equation. This only applies to the Actual Value because it is calculated.
- By default, if a KPI equation is referencing a value that is blank, the entire equation will immediately evaluate to blank. You can instead choose to treat missing values in the equation as 0, N/A, or Blank.
- This is the button to set the KPI's equation. We'll cover that next.
When you click the Set Equation button, it shows a dialog for building the equation for that series.
- This is where the equation that we're building goes. You can type text directly here.
- This builds functions that we send into the equation.
Next we're going to choose the KPI that we want to reference by clicking the Select a KPI button.
This stacks a second-level dialog where we choose the Product Revenue KPI.
When we click Done and the second-level dialog closes, our equation builder now looks like this.
- The item type is KPI. We'll explain below how to reference other things like Initiatives and Scores.
- This is the Product Revenue KPI that we selected. If you want to change the item we're going to reference in the equation, just click this button again.
- We're going to include Product Revenue's actual value in the equation, but we could reference one of its thresholds like Goal instead.
- We're going to include Product Revenue's value for the current period, but we could choose earlier or later periods.
- When we're ready to add the data to the equation, click this Add button.
Once you add a reference to a KPI, it looks like this:
Now we'll type in a [space], a [+], and a [space], select the Training Revenue KPI in the second-level dialog...
... and click Add.
One more time and our equation is finished. Let's click Done.
Back on the Edit tab, our equation now shows up for the Actual Value series.
When we save the KPI and visit the Scorecards Overview tab, we can now see our calculated KPI in action.
You can also choose This KPI when building equations. This allows you to make self-referential equations, for example goals that are automatically 10% higher than the previous year’s actual value.
You can include the score from any scorecard item in your equation. Just select Score from the Type dropdown on the left.
Referencing Initiative Values
You can include vales from Initiative items by selecting Initiative in the Type dropdown on the left. Here we're using the Total Budget from the Migrate Servers to the Cloud initiative in our equation.
By choosing To Date in the Type dropdown, you can build equations that aggregate values over time. In this example we're including the Sales Revenue quarterly sum.