Databases Reference
In-Depth Information
3.
Next, navigate to the
Airline Operations\Design
folder and select the
warning.gif
image file.
4.
On the
Layout
tab, set the
Layer
to
Top
.
5.
Click on
OK
to close the dialog window.
6.
Position the warning icon over the
Transported passengers (millions)
text
object so that it looks like the following screenshot:
One thing to make note of is the
Layer
setting. By setting it to
Top
, we ensure that
the icon is always superimposed over the
Transported passengers (millions)
text
object. This is important, otherwise we will not be able to select it using the mouse.
Furthermore, if we hadn't set the
100%
transparency in the
Transported passengers
text object, having the icon in a lower layer would prevent it from being visible to
the user.
Remember that we can always access any object's properties via
the
Objects
sheet of the
Sheet Properties
dialog (
Ctrl
+
Alt
+
S
).
The current result is almost what we want. However, you'll notice that the icon is
displayed, even though there are more than 1 million transported passengers, which
is the specified limit. Let's take a moment to fix it by using the following steps:
1.
Right-click on the warning icon and select
Properties…
.
2.
Go to the
Layout
tab and select the
Conditional
radio button under
Show
.
3.
Enter the following expression:
Sum([# Transported Passengers]) < 1000000.
4.
Click on
OK
to close the
Text Object Properties
dialog window.
Now the warning icon will only be shown when the specified condition is met; that
is, when the number of transported passengers is lower than 1 million. To test it,
you can make a few selections, for example, by selecting the year
2011
and
Piston,
1-Engine/Combined Single Engine
from the
Aircraft Group
.
Adding these type of visual cues to our dashboard will make it easier for the users to
spot potential issues.
