Dashboard

Some fellow Dashboard Spies and I were discussing the rising popularity of Microsoft Sharepoint server for executive dashboard applications and the topic of conditional formatting and graphical red/green/yellow status indicators arose. Were dashboard traffic lights available in SharePoint right out-of-the-box?

We found this nice video demonstration of how to tweak the Sharepoint code so that you do get red/green/yellow lights on a simple list:

The Dashboard Spy is all about screengrabs, so I extracted some images for you to take a quick look in case you don’t have time to watch the video right now. Here is the view of the color state images:

And here is a look at the part where he is tweaking the code to make the conditional display logic work:

Tags: Sharepoint Dashboards, Sharepoint dashboard indicators

What do you think about this dashboard post? Please leave a comment. Your opinions are valuable to the entire business dashboarding community.  

4 Responses to “SharePoint Dashboard Conditional Indicators”

1. Web Standard Templates for MS SharePoint « The Dashboard Spy Said on November 9th, 2007 at 8:39 pm quote

   [...] I pointed her to several SharePoint Dashboard videos on the dashboard screenshot blog - Dashboards By Example.  After we jointly studied a couple more dashboards done in SharePoint, our discussion turned to [...]

2. AnyChart Said on February 4th, 2008 at 3:00 am quote

   You can also use charts to do the same:
   http://www.anychart.com/blog/2008/02/04/add-interactive-charts-to-your-microsoft-sharepoint-portal/

3. Joe Said on July 14th, 2008 at 1:21 am quote

   Great tutorial, but I have one problem with the result. In one of my columns, I’m using a person’s name, and even though I have the “presence indicator” turned off, once I make these changes in Sharepoint designer, the presence indicator shows back up. When it comes back, it’s on the right side of the name rather than the usual left…

   This is a problem because it distracts from the status indicators that were my goal in the first place.

   Any advice on how to remove these?

4. Christophe Said on November 19th, 2008 at 7:26 am quote

   I just came across your article, and wanted to share a method to diplay indicators in SharePoint (2003 or 2007). Here is the link:
   http://pathtosharepoint.wordpress.com/2008/09/01/apply-color-coding-to-your-sharepoint-lists/

   My method is easier and is entierely applied through the SharePoint UI (no FrontPage or SharePoint Designer).

Leave a Reply

Last Modified: Friday, July 27th, 2007 @ 10:14

This business intelligence dashboard blog entry was posted on Friday, July 27th, 2007 at 10:02 am and is filed under Dashboard Screenshots. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.

Dashboard Spy Readers: See these related Business Intelligence Dashboard posts:

• SharePoint 2007 Project Dashboards with Corasworks Web Parts
...
• Microsoft SharePoint 2007 Hard to Skin?
...
• SharePoint Dashboard for Marketing Campaign Tracking
...
• Building an Executive Dashboard in Excel 2007 with Conditional Formatting
...
• Screenshot of a Performance Evaluation Dashboard from the SharePoint Template Series
...
• Security Update Patch Management Dashboard for Monitoring Patch Status
...
• SharePoint Template for a Competitive Intelligence Dashboard
...
• Microsoft Dynamics Dashboard - A CEO Scorecard Example
...

Latest posts of interest to the business intelligence dashboarding community - Have you read these recent enterprise dashboard posts?

Recently Posted

• Federal IT Dashboard
• Financial Crisis Dashboard
• GIS Dashboards
• Economic Recovery Dashboard for Financial Advisors
• Impact of Gaming on Business Dashboard Design
• SAS Graph iPhone Dashboard
• Switching Dashboards
• Effective Dashboard Design Presentation
• Donation Portfolio Dashboard
• Google Local Search Dashboard