Sharepoint Forum

Ask Question   UnAnswered
Home » Forum » Sharepoint       RSS Feeds

KPI list

  Asked By: Dominique    Date: May 10    Category: Sharepoint    Views: 1930

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"?



1 Answer Found

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

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.