Filter Data Dynamically in Xcelsius
One of the biggest challenges Xcelsius developers face when building dashboards is dynamic filtering of data once it is loaded into the SWF. Whether data originates from Excel or web services, end users require a dynamic user experience that involves filtering and summarizing information on the fly. In cases where data volume is relatively low (under 1500 rows) you should have the flexibility to filter and summarize data on the fly without layers of Excel logic dependencies.
While Xcelsius does not addressed both dynamic filtering and summarization of data out of the box, Filtered Summary plugin does. This component provides maximum flexibility to combine filtering and summarization capabilities together. We built this component with an Xcelsius developer in mind by providing a data preview tab in the property sheet. This gives the developer a quick preview of how the data will look before it is placed into the destination range.
To demonstrate this component and I have started a new dashboard pet project in anticipation of the 2010 world cup. With a full list of matches for the group stage in June, I wanted to provide an interface where an end user could quickly view matches by team or group. Using Filtered Summary, this simple application was built without a reliance on Excel logic or Xcelsius workarounds.
I will continue to refine this particular dashboard as we get closer to World Cup.