Solved

Need help creating Sharepoint KPI

Posted on 2010-08-16
7
1,285 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
PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

 

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

Free Gift Card with Acronis Backup Purchase!

Backup any data in any location: local and remote systems, physical and virtual servers, private and public clouds, Macs and PCs, tablets and mobile devices, & more! For limited time only, buy any Acronis backup products and get a FREE Amazon/Best Buy gift card worth up to $200!

Join & Write a Comment

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…
The vision: A MegaMenu for a SharePoint portal home page The mission: Make it easy to maintain. Allow rich content and sub headers as well as standard links. Factor in frequent changes without involving developers or a lengthy Dev/Test/Prod rel…
This video discusses moving either the default database or any database to a new volume.
Illustrator's Shape Builder tool will let you combine shapes visually and interactively. This video shows the Mac version, but the tool works the same way in Windows. To follow along with this video, you can draw your own shapes or download the file…

759 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

Need Help in Real-Time?

Connect with top rated Experts

19 Experts available now in Live!

Get 1:1 Help Now