Learn more about SQL Server tools

mssqltips logo
 

Tutorials          DBA          Dev          BI          Career          Categories          Webcasts          Whitepapers          Today's Tip          Join

Tutorials      DBA      Dev      BI      Categories      Webcasts

DBA    Dev    BI    Categories

FREE Webcast - Delivering Microsoft SQL Server High Availability on AWS
 

SharePoint KPIs Part 3 - Create KPIs from SharePoint Lists


By:   |   Read Comments   |   Related Tips: > Sharepoint

Problem

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.

Solution

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.

emp name

Now let us create a KPI from the SharePoint List. Go to KPI List->New and select "Indicator using data in SharePoint list".

new

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.

sales employee list

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.

value calculation

Click Ok and you can see the result. In our case it is a yellow status as it has not met the goal target.

sales employee list

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.

indicator

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.

sales employee list
Next Steps
  • 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 SharePoint lists.


Last Update:


next webcast button


next tip button



About the author
MSSQLTips author Rahul Mehta Rahul Mehta is a Project Architect/Lead working at Tata Consultancy Services focusing on ECM.

View all my tips





Post a comment or let the author know this tip helped.

All comments are reviewed, so stay on subject or we may delete your comment. Note: your email address is not published. Required fields are marked with an asterisk (*).

*Name    *Email    Email me updates 


Signup for our newsletter
 I agree by submitting my data to receive communications, account updates and/or special offers about SQL Server from MSSQLTips and/or its Sponsors. I have read the privacy statement and understand I may unsubscribe at any time.



    



Learn more about SQL Server tools