Dashboard Multi-Layer Control: A Best
This article gives you a best practice for providing multi-layer control of your interactive dashboard. The overall approach to multi-layer control is to set-up a mapping that tells Crystal Xcelsius exactly how you want it to behave.
The Double Edge Sword:
One of the nice features of Crystal Xcelsius is that
you can dynamically adjust the visibility of components in your dashboard.
Since the dashboard design is a creation of your imagination, you have
complete freedom to control what becomes visible, and when. This is fine
when you have simple on/off criteria, but can be messy to construct and
keep track of when you have many components that work together in certain
Create a context:
The methodology is straight forward and relatively simple. The first step is to create a context which can signal specific actions or modes of behavior in your dashboard. Perhaps the most obvious mechanism for this is the Crystal Xcelsius Label Based Menu (see Figure 2)
The menu retrieves the name of each button from your embedded spreadsheet, and most importantly, inserts information into a specific location in the spreadsheet when a button is pressed (see Figure 2).
Create a Mapping and Switching Circuit:
The menu in this example has five buttons or groups (Introduction, Calendar, Animation, Property Mgmt Calculator, and Behind the Scenes). Think of these as Groups 1-5. For each menu context, certain components should be turned on, and others turned off. This is done via a visibility control logic map in your spreadsheet (see Figure 4).
In Figure 4, the "1" signifies the "on" state, and the blank (or zero value) signifies the "off" state. For example, according to the logic map, when the first menu button (Introduction)is clicked, the components in Groups 0, 1, 6, and 8 are made visible. Similarly, when the fifth button (Behind the Scenes) is clicked, the components in Groups 1, 5, and 7 are made visible.
You can designate which of your dashboard components are "members" of each group (see Figure 5).
To complete the process, create a "Switching Circuit" so the various components can follow a single on/off element tailored to the component and all the logic elements (see Figure 6).
Components that can be turned on or off might include individual elements like a slider, or a whole assembly of components, such as a standalone dashboard (see Figure 7).
Putting it all together:
The menu, logic map, and switching circuit are all part of your Excel spreadsheet you import into the Crystal Xcelsius work area when creating your interactive dashboard (see Figure 8).
There are many ways to manage the visibility of
components in an interactive dashboard. We offer this best practice as one
that is simple and elegant, and easy to extend.
Loren Abdulezer is the CEO of Evolving Technologies Corporation (ETC), and author of the best-selling Excel Best Practices for Business. ETC, an Xcelsius Consulting Partner, is a technology consulting firm based in New York City. More information about Xcelsius can be found on Loren's web site: XcelsiusBestPractices.com. He can be reached at firstname.lastname@example.org. The files referenced in this article can be found in the Article Reprints section of: http://www.xcelsiusbestpractices.com/
©2005 Evolving Technologies Corporation - all