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?


  • any luck with that? i'm working on the exact same thing.
    – user7494
    Commented Mar 23, 2012 at 9:13

2 Answers 2


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


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!

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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