Hi,
I have three SharePoint lists:
1. List of projects with project number and SBS code:
2. List of events: Which stores events associated with various products. it has milestones and Due dates
3. List of activities: This is where each activity is recorded with its actual date of accomplishment. So we need to compare the actual Date of accomplishment with the due date set in List of events in above and output a status icon. Each Activity is associated with a project (from Projects List) and with a unique combination of Product and Event from Events list.
I would like to show icons as follows:
§ Green – If activity is complete by date as specified In Events list.
§ Yellow – If activity is not complete in Activity List and within 30 days of due date as specified in Events list.
§ Red – If activity is not complete in Activity List and past due date as specified in Events list.
I want the Dashboard to show a summary view instead of spanning it through entire browser width. I have attached Excel mock up of the data that I intend to see ..however I need a much more cool Interactive UI where a user can View Results easily. I prefer using JavaScript and JQuery or Knockout javascript libraries combined with SharePoint Ecmascript client object model.
Let me know if you have any questions
I will use PHP and Felx to build a very attractive Flash based dashboard.
I am a professional dashboard builder and well aware of the usability aspects of it.