We've been tasked with using SharePoint 2010 to create a dashboard for at-a-glance production line status.
The line is broken into different areas each with their own status indicator:
green when no problems and
red when production in that area is down. Each area has 3 sub-areas that each have their own status indicators. We need the line area indicators to depend on their sub-area indicators i.e. a given area indicator would turn green only if all it's sub-areas are green.
Is this possible with SP2010, without the use of dashboard designer (we don't have this functionality)?
I was working off a blog http://blog.pathtosharepoint.com/2009/06/26/case-study-kpi-roll-up-in-moss-2/ which is similar to what we want to achieve but doesn't have the dependence relationship between indicators that we require.
Are there any other approches that you could recommend?