Databases Reference
In-Depth Information
In the preceding example, the total flights in
Group A
(represented by the blue bars)
correspond to those coming from outside the US, arriving at Chicago, and performed
by US carriers, as depicted in the corresponding current selections box on the left.
Group B
(represented by the brown bars) covers flights departing from Chicago,
bound to California, and performed by US carriers as well, as depicted in the current
selections box on the right.
We can easily see how the amount of flights performed by
Group A
is greater to that
of
Group B
during the first five months of 2011, it is almost equal during June and
July, and it is lower during the rest of the year.
Alternate states step-by-step
We have been able to define two different record sets and compare the
corresponding results side-by-side by enabling the
alternate states
functionality.
To see how this works, let's build the preceding chart, step-by-step, by following
this procedure:
1.
Open the
Airline Operations.qvw
document we have been working with.
2.
Click on the
Add Sheet
button from the
Design
toolbar to create a new sheet.
3.
Right-click on an empty space of the worksheet area of the new sheet and
select
Properties…
.
4.
From the
Sheet Properties
window, activate the
General
tab and enter
Comparative Analysis
into the
Title
field.
5.
Click on
OK
in the
Sheet Properties
window.
6.
Now, navigate to
Settings | Document Properties…
and activate the
General
tab from the
Document Properties
window.
7.
Then, click on the
Alternate States…
button and a new pop-up window
will appear , as seen here: