Go 4 Sharepoint

Search:

Welcome: Guest!

Sharepoint Forum

Home » Forum » Sharepoint

Ask a question

RSS Feeds

KPI list

Asked By: Dominique Higgins Date: May 10, 2010 Category: Sharepoint Views: 480

I created a KPI list based on a task list, where I added a "completed on"
column in order to compare with "due date" column.

How should I tell the KPI list to produce the percentage of those tasks
where task "compelted on" column is equal or less than "due date"?

Tagged:kpi list

1 Answer Found

Answer #1 Answered By: Darrius Whitfield Answered On: May 10, 2010

In order to do this computation you have to know two numbers:

Number of tasks done on time
Number of tasks not done on time

Both these numbers would be an aggregation of the entire list.
SharePoint does not provide, out of the box, this sort of aggregate
computations on all the rows in a List. When I need this sort of thing
I use Access and/or Excel to do the computation.

Didn't find what you were looking for? Find more on KPI list Or get search suggestion and latest updates.

Your Answer

Answer should be atleast 30 Characters.
Please put code inside [Code] your code [/Code].

Please login to post comment

Previous: Various forms options

Next: How to enable Enterprise Keywords in a Blank site in SharePoint 2010?

Go4Sharepoint, is a Microsoft Featured Community. Microsoft, Windows, Sharepoint, Sharepoint logo, Windows logo, etc are trademarks of the Microsoft Corporation. All product names, logos, copyrights, and trademarks mentioned are acknowledged as the registered intellectual property of their respective owners. This site is not in any way affiliated with, nor has it been authorized, sponsored, or otherwise approved by, Microsoft Corporation.