Databases Reference
In-Depth Information
Gauges
After our little detour on linked objects, let's start building the dashboard by adding
three gauge charts, one showing a global indicator of
Load Factor %
, the second
showing
Performed vs Scheduled Departures ratio
value, and the third showing
the
Air Time %
value.
1. Start by adding a new chart object with the
Create Chart
button located on
the design toolbar.
2. From the first dialog window, make sure to select
Gauge
as
Chart Type
.
3.
In the
Window Title
field, enter
Load Factor %
as the name of the chart
and click on
Next
.
4.
This chart type does not make use of dimensions, so we'll skip this window
and click on
Next
once more to get to the
Expressions
dialog window.
If a dimension is present in the gauge chart, the gauge
will show the value for the first sorted value in the
dimension field. Always ensure, that no dimension is
selected. This is especially important to keep in mind
when using
Fast Type Change
on charts.
5.
Add the following expression in the
Edit Expression
dialog window and
click on
OK
to continue:
Sum ([# Transported Passengers]) / Sum ([# Available Seats])
6.
The expression that we just created will calculate the percentage of occupied
seats compared to those that were available on each flight.
7.
The
Label
we'll assign to this expression will be the same as the
Window
Title
field that we previously defined:
Load Factor %
.
8.
Click on
Next
three times, until you are at the
Presentation
window, and set
the following configuration under the
Gauge Settings
section:
°
Min
and
Max
values will be
0.5
and
1
respectively
° From the
Segment Setup
section, we will add two more segments by
clicking on the
Add…
button twice
° Deselect the
Autowidth Segments
checkbox at the bottom of
the window