Databases Reference
In-Depth Information
3.
In the
Comment
field, enter
Variable to calculate the number of
departures performed with variable divisor
.
4.
Close the
Variable Overview…
window by clicking on
OK
.
We already have a similar variable, called
eDeparturesPerformed
, which is used
to store an expression that calculates the number of flights performed in thousands.
The difference this time is that we are inserting a parameter as the divisor. This
parameter is represented by
$1
, and will allow us to use the same variable to obtain
the corresponding expression and calculate the number of flights performed in
millions (by defining the parameter as
1000000
), thousands (when the parameter is
1000
), units, and so on.
To use the above variable in an expression, start by creating a new chart in the
form of a straight table with
Carrier Group
as the dimension and the following
three expressions:
1. The first expression, labeled
# of Flights
, will be:
$(eDeparturesPerformed_VarUnit(1))
2.
The second expression, labeled
# of Flights (thousands)
, will be:
$(eDeparturesPerformed_VarUnit(1000))
3.
The third expression, labeled
# of Flights (millions)
, will be:
$(eDeparturesPerformed_VarUnit(1000000))
The only difference in the previously mentioned expressions, apart from the label,
are the parameter values inserted into the variable.
After properly formatting the expression values and the chart's presentation, we will
have the following chart: