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.
Looking good Ryan, looking forward to further development and wondering how you will visualize the championship as soon as it’s won by The Netherlands
Ryan excellent concept. Though world cup is here, can this be extended to actually tell world cup story since 1930? – filtered by year. So, the dashboard will be evergreen.
World cup started in 1930. The winners have been between South America and Europe. I am visualizing a dashboard using GMapsPluging and GoogleMap to summarize the world cup story in http://www.planetworldcup.com/index.html
This tournament will be historical, the first time in African continent and the first time an African team will win the cup.
Nigeria all the way!!!!!!
I had initially started down that path, but unfortunately could not get it wrapped up before the world cup.
Here is a sweet world cup match finder at MyXcelsius: http://myxcelsius.com/2010/06/11/xcelsius-fifa-world-cup-2010-match-finder/
Thanks for the comments.
Good effort ryan! I came across your site while searching for filtering components in xcelsius. I was facing some problem in it coz was uable to get output in excel/worksheet from filter component. Which version are you using coz I had downloaded from the link you mentioned and wasnt able to open it as its shown here on website. I am using xcelsius 2008 SP1. Your suggestions will be appreciated.
All the very best!
Ryan, This is exactly what I was trying to develop for a dashboard. Great thoughts!
I downloaded the excelsius file. But, it does not show how you populate all the excel rows in the “Soccer” sheet from N4:R100. The excel version seem to be incomplete and does not behave exactly as the web version. Please help. Not sure if I am missing something.
Really appreciate any help. Your site is extremely useful. Thank you.
Goutham.