SharePoint KPIs Part 3 - Create KPIs from SharePoint Lists
Written By: Rahul Mehta -- 2/2/2011 --
(28) comments --
Categories: Design, MOSS 2007
Lists are one of the most commonly used data structures in SharePoint. Consider a scenario when
a summarized value of this data needs to be measured and reported. Consider a scenario where your entire employee sales data resides in
a SharePoint list and is regularly updated, and you want a KPI to use the
SharePoint list as a data source for reporting values.
In this tip we will discuss how to generate a KPI based on a SharePoint List. For our scenario, we have created a
SharePointcustom list which contains employee sales data.
Now let us create a KPI from the SharePoint List. Go to KPI List->New and select "Indicator using data in
We can divide our task into two parts. The first part is to enter basic information like
the KPI Name, the SharePoint Custom List location where our source data exists, and
the SharePoint Custom List View Name which would provide the set of data/items.
The second part is to decide what kind of values to display. One can select to perform calculations on
a column in different ways.
In our scenario, we will take an average of sales of all employees, which will help to measure a single target of
all employees sales at one time.
To perform such calculations, select "Calculate using all list items in the view".
We select "Average" and "Empsales" as the target column. Set a goal and a warning value as
shown in the image below.
Click Ok and you can see the result. In our case it is a yellow status as it
has not met the goal target.
Now let us test the connection by changing the values in the Employee Sales Custom List
so that their average goes below the warning level range. The result will be something like
the image below.
One can view the detail by clicking on it. This will display the goal, actual and warning values of
the KPI with the attached SharePoint custom list.
- Use this approach to create a centralized KPI dashboard that could contain KPIs
from different business units. The data sources would actually reside in different
- Return to
MSSharepointTips to read about other topics and ideas.
- Check out MSSQLTips.com for great
information about Microsoft SQL Server.