In the world of data analysis, charts and tables are gateways to human. Charts communicate size and quantities to human via human's natural perception of the world. However, when multiple facets of data are presented, relating size and quantities to facets becoming a burden to human. Tables, on the other hand, relate multiple faceted data in concise form to human sacrificing the advantage of human's natural perceptions for size and quantities.
The proposed user interface design is based on the above observations about tables and charts. The interface begin by presenting a data table to user with the associate charts: (Two flavor of charts are presented - vertical and horizontal bar)
It is obvious that these charts are difficult to comprehend with the mixed facets of institutional and sectional totals. The idea behind the design, however, is to provide user with channel tools that can channel desired data to the the chart. Various ways can be used to select the desired data. For example, using drop-down list, checkboxes in context menu, or text/regular-expression based filtering to channel the desired data. Visual feedback can be provided to user by hiding or highlighting the data table. Possible filtering results are presented below: