Solved

Need help creating Sharepoint KPI

Posted on 2010-08-16
7
1,327 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
[X]
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
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
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 

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

Three Reasons Why Backup is Strategic

Backup is strategic to your business because your data is strategic to your business. Without backup, your business will fail. This white paper explains why it is vital for you to design and immediately execute a backup strategy to protect 100 percent of your data.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Sharepoint workflow on list 7 51
InfoPath Business days 1 72
Sharepoint KB 2 87
Sharepoint User Name Displaying incorrectly. 17 83
Last week I faced a strange issue recently, i have deployed SharePoint 2003 servers for one project and one of the requirements was to open SharePoint site from same server. when i was trying to open site from the same server i was getting authentic…
A recent project that involved parsing Tableau Desktop and Server log files to extract reusable user queries for use in other systems. I chose to use PowerShell to gather the data, and SharePoint to present it...
Email security requires an ever evolving service that stays up to date with counter-evolving threats. The Email Laundry perform Research and Development to ensure their email security service evolves faster than cyber criminals. We apply our Threat…
The Email Laundry PDF encryption service allows companies to send confidential encrypted  emails to anybody. The PDF document can also contain attachments that are embedded in the encrypted PDF. The password is randomly generated by The Email Laundr…

756 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