Databases Reference
In-Depth Information
After clicking on
OK
to apply the above changes, resize and reposition the chart on
the screen to occupy an appropriate part of the upper space of the window. What we
should have so far is:
With the above user interface, a user can now start making queries, filter data, and
see how the chart updates with every new selection. We can, for example, ask a
question like: How many flights per year have been performed by foreign carriers?
How many of those flights were domestic and how many were international?
However, let's enhance the functionality a bit more.
One chart and multiple analyses with cyclic
expressions
We will now add one more level of interactivity to our chart by using a
Cyclic
Expression
group. Having a cyclic expression means the user will have the ability
to interactively change the measure or formula used in a chart.
The cyclic group we will create will hold expressions to calculate the number of
flights, number of enplaned passengers, total freight, and total mail transported.
