|
|
Use a Bar or Pie Graph to Drill Down into Data
Drill down is an excellent way to allow users to ask follow up questions of a report or analysis. In Proto, the ability to create a drill down effect is extremely general, and it is simply based on driving additional processes (filtering, analysis, database queries, etc.) based on a users interaction with a report (selecting a row in a table, clicking on a graph, etc.). The construction of any drill down effect follows this pattern:
-
Provide some report or display of information that a user can interact with. Examples include graphs, presentation tables, custom summary reports, listboxes, etc.
-
Based on the dynamic output from a presentation control (a selected pie slice, a double-clicked cell in Table, etc.), use some identifying characteristic to trigger a subsequent process. The simplest and most common example is using the category from an aggregate report such as a Pie graph, to trigger a filter that outputs all the underlying rows of data for the selected category.
-
Use the data related to the the users action to produce a follow up report or analysis. In the Pie graph example, the underlying rows of data may simply be displayed in table. However, you can create much more sophisticated examples of "drill down" to show related reports, analysis, etc. based on a users interaction with one report.
The example file shows how to aggregate data, show it in a pie graph and then drill down to show the underlying rows.
|
