Solved

Need help creating Sharepoint KPI

Posted on 2010-08-16
7
1,314 Views
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.

Thanks
0
Comment
Question by:MisUszatek
  • 4
  • 3
7 Comments
 
LVL 9

Expert Comment

by:SharePointGirl
ID: 33450289
Can you post the calculation?
0
 

Author Comment

by:MisUszatek
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.
0
 
LVL 9

Accepted Solution

by:
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

=IF(ISBLANK([Column1],1,0)

and then use this field in your value calculation
0
Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

 

Author Comment

by:MisUszatek
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 ?
0
 
LVL 9

Expert Comment

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

Author Comment

by:MisUszatek
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.
0
 
LVL 9

Expert Comment

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

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

0

Featured Post

Back Up Your Microsoft Windows Server®

Back up all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

Question has a verified solution.

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

Suggested Solutions

Summary In SharePoint 2010 it is easy to create custom color themes to jazz up a site. Theme colors can also be created in PowerPoint 2010 with a few clicks. But how do the chosen colors actually look in the SharePoint site? The attached PowerPoint…
These days socially coordinated efforts have turned into a critical requirement for enterprises.
Established in 1997, Technology Architects has become one of the most reputable technology solutions companies in the country. TA have been providing businesses with cost effective state-of-the-art solutions and unparalleled service that is designed…

792 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