Databases Reference
In-Depth Information
The end result should be a gauge chart that looks like this:
Cloning the object for re-use
Since we have already created a gauge chart with several specific configurations, let's
make use of it to create a new one without having to do the whole process over again.
Right-click on the gauge chart we created previously and click on the
Clone
option.
A new copy of the object will be created exactly as the previous one; the only thing
we will need to do is re-position it and change its expression and title, as well as the
text in the chart.
Right-click
on the new cloned object and select
Properties…
to make the
following changes:
1.
In the
General
tab, the
Window Title
field will be
Performed vs Scheduled
.
2.
The expression we will use is:
Sum([# Departures Performed]) / Sum([# Departures Scheduled])
3.
The label for the expression is the same as the
Window Title
field:
Performed vs Scheduled
.
4.
On the
Presentation
tab, change the following settings:
° Set the
Max
value for the gauge to
1.2
° Set the
Show Scale
value to
8 Major Units
° Set the
Show Labels on Every
value to
1 Major Unit
° Highlight the
Text in Chart
expression that we added previously and
click on the
Edit…
button. Change the expression to:
=Num(Sum([# Departures Performed]) / Sum([# Departures
Scheduled]), '##.#%')