SharePoint List based Status Indicator

Introduction:

Status Indicator is a one - line report type which is used to show and compare the actual performance of particular measure with the goal value. In this article we will be seeing how to create SharePoint List based Status Indicator. SharePoint List based Status Indicator is used to show a value based on the contents of a SharePoint list. In this I am going to create a status indicator based on the % complete of the tasks in the tasks list.

To create a status indicator based on SharePoint list we need to do the following steps:

1. Create a status list.
2. Add the Status indicator to the status list.

Note: You should have a site created based on Business Intelligence center template.

Create a Status list:

1. Go to the Business Intelligence Center site.
2. Go to Site Actions => More Options.
   
   
    
3. Select the "Status List" template, enter the list name and click on Create.
   
   
    
4. I have a tasks list with the following items.
   
   
    
5. I am going to create indicator based on the average value of % complete.

Add the Status indicator to the status list:

1. Go to the Status List we have created.
2. Click on the down arrow available near New button.
3. You could see "SharePoint List based Status" option.
   
   
    
4. Click on that.
5. Enter the Name, Description and Enter the Tasks List URL as shown in the following.
   
   
    
6. Value Calculation - Average of % complete value.
   
   
    
7. Goal value 75% and Warning value 50%.
   
   
    
8. Click on Ok.
9. Now you could see the indicator created for the SharePoint list based on the average value of % complete as shown in the following.
   
   
    
10. Click on the Indicator (Indicator based on SharePoint list), you could see the following