Databases Reference
In-Depth Information
We now have a bar chart showing the number of flights per year. We can drill down
to see a monthly trend by clicking on one of the bars, which initially represents a
year. Another way of drilling down is by making an in-chart lasso selection covering
one of the bars. Our chart should look like the following screenshot:
Navigating back up
When drilling down, you can go back to the previous level
in the
Drill-down Group
by either clicking on the up-facing
arrow next to the field name in the legend box (down to the
right), or by clicking the
Back
button on the navigation toolbar.
With the functionality presented in this section, as well as in the previous one, the
user is free to decide how he/she wants to visualize the data: selecting, slicing,
drilling, and swapping as per his/her convenience. Also, the space taken up by one
single chart can be used to make a lot of different analyses with just a few clicks.
Besides drill-down groups, we can also create cyclic groups for the
user to interactively change a chart's dimensions. This is similar to
what we did with the cyclic expression. The procedure to create a
cyclic group dimension is the same as the one described above for
drill-down groups, we just select
Cyclic Group
instead of
Drill-
down Group
in the
Group Settings
dialog window.
Top 10 routes
We will now add a chart in the form of table to display the top routes in terms of
number of flights, enplaned passengers, transported freight, and transported mail.
Let's call it
Top 10 Routes
.
