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.