Drilling from a graph
It's interesting to note that Discoverer enables you to drill from the graph associated with a worksheet. Continuing with the example in the preceding section, the graph associated with the worksheet you can see in the previous figure should look like this:
Looking to the right in the above graph, you may notice the Orddate: Year link, which you can click if you want to drill up to year figures. But how can you drill down to, say, month figures? The answer is you can double-click any graph bar to drill one step down. Thus, in this particular example, if you double-click a graph bar, you'll launch a drill-down from quarter data to monthly data. So the result worksheet would look like the following one:
The graph will also be automatically redrawn. This should look now like the following screenshot:
Each bar in the above graph represents figures associated with a particular month. In this particular example, this can be either January or March figures. To find out...