SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

My problem is this:

I need to create a dashboard/KPI in SP2010 that will show the progress of a certain project.

The progress should be counted via the number of tasks/milestones completed in the said project. Tasks can be added anytime so the progress on the dashboard should also adjust in realtime.

I noticed that a KPI/status list only counts numerical data, so question is:

Is there a way to count the number of tasks in a list (filtered by project name column) and show in the dashboard how much of the project is done based on tasks done/total tasks -- and display it as a KPI?


share|improve this question
any luck with that? i'm working on the exact same thing. – user7494 Mar 23 '12 at 9:13

Was working on same thing also but i found you cannot add chart/reports to dashbored unless you create a Sql Server Analyses Service (Cube) as data source, which is not feasible in our current scenario... however if you find any solution do mention it, thanks

share|improve this answer

This can be done with little effort by using XSL.
I have just posted a blog post to answer this.

I hope it will help!

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.