Need help creating Sharepoint KPI

Posted on 2010-08-16
Last Modified: 2012-05-10
I would like to create a KPI that would check if the values in column A are empty and show the following:

Green light -> 100% of items in the list have value in column A
Yellow light ->50-100% of items in the list have value in column A
Red light ->0-50% of items in the list have value in column A

I was playing around with it but keep getting the "The specified value calculation is not valid. Specify a valid value calculation" error message.

I use MOSS 2007.

Question by:MisUszatek
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 3

Expert Comment

ID: 33450289
Can you post the calculation?

Author Comment

ID: 33450300
Under "Value Calculation: " I selected  "Percentage of list items in the view where". Then I tried to choose the column name, then "is equal to" and leave empty the value field.

Accepted Solution

SharePointGirl earned 250 total points
ID: 33450363
I would create a calculated column which has a value of 1 if the field is not null


and then use this field in your value calculation
Office 365 Training for Admins - 7 Day Trial

Learn how to provision tenants, synchronize on-premise Active Directory, implement Single Sign-On, customize Office deployment, and protect your organization with eDiscovery and DLP policies.  Only from Platform Scholar.


Author Comment

ID: 33450438
I got the error first but it was just missing the bracket. How can I modify this calculation to check for the value in two columns with OR ?

Expert Comment

ID: 33450453
No just use the calculated field and use percentage where value is less than 1

Author Comment

ID: 33450464
Let me rephrase it: how to change your formula to check if a value in Column A OR B is blank. Then I will do the KPI based on that.

Expert Comment

ID: 33450484
IF(NOT(ISBLANK([Column1])), IF(NOT(ISBLANK([Column2])),1,0),0)

Sorry I have not got SharePoint up and running to check.


Featured Post

Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

The Scenario: Let’s say you have a quote worksheet in Excel that you use to work up sales figures and such for your clients. You utilize SharePoint to manage and keep track of these documents. You would like values from your worksheet to populate Sh…
Pimping Sharepoint 2007 without Server-Side Code Part 1 One of my biggest frustrations with Sharepoint 2007 in the corporate world is that while good-intentioned managers lock down the more interesting capabilities of Sharepoint programming in…
In this video, viewers are given an introduction to using the Windows 10 Snipping Tool, how to quickly locate it when it's needed and also how make it always available with a single click of a mouse button, by pinning it to the Desktop Task Bar. Int…
In this video we outline the Physical Segments view of NetCrunch network monitor. By following this brief how-to video, you will be able to learn how NetCrunch visualizes your network, how granular is the information collected, as well as where to f…

615 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question