Databases Reference
In-Depth Information
To create a cyclic expression, right-click on the
Traffic per year
chart and select
Properties…
from the context menu.
Since we already have the first expression created, we will continue by beginning to
create the second one. Activate the
Expressions
tab and click on the
Add
button. In
the
Edit Expression
dialog window, type the following expression:
Sum ([# Transported Passengers])
Click on
OK
and set the label for this expression as
# of Enplaned Passengers
.
Make sure this second expression is highlighted and click on the
Group
button. This
will automatically create the cyclic group for our expressions.
Click on the
Add
button once more and add the following expression:
Sum ([# Transported Freight])
The label for this expression will be
Transported Freight
. Make sure the new
expression is highlighted and click on the
Group
button again.
Click on the
Add
button again to add our last expression:
Sum ([# Transported Mail])
The label for this expression will be
Transported Mail
. Make sure the new
expression is highlighted and click on the
Group
button again.
Finally, go to the
Number
tab and make sure that all of our expressions are
formatted as
Integer
. Click on
OK
to apply the changes.
After following this procedure, our chart will have the ability to change its active
expression (metric) through a cycle button (in the form of a circular arrow) that will
be placed at the lower-left corner of the object.
The user can select the measure that he/she wishes to activate by either clicking on it
directly to sequentially change the chart's expression, or by clicking on the little black
down-arrow to display the drop-down menu from which the desired expression can
be selected.
We can also activate the drop-down menu by right-clicking
anywhere inside the cycle button.