Databases Reference
In-Depth Information
Adding a Pie chart
The final metric that we want to display on our dashboard is Market Share. This
metric is based on the number of enplaned passengers per carrier, relative to the
total. We will use a
Pie Chart
to visualize this measure. Let's follow these steps:
1.
Right-click on an empty space in the sheet and select
New Sheet
Object
|
Chart
.
2.
On the
General
tab, select the
Pie Chart
option as the
Chart Type
, the third
icon from the left on the bottom row, and click on
Next
.
3.
On the
Dimension
tab, select
Carrier Name
from the
Available Fields/
Groups
list and click on the
Add >
button to add it to the
Used Dimensions
list. Click on
Next
to continue.
4.
In the
Edit Expression
dialog, enter the following expression and click on
OK
:
Sum([# Transported Passengers])
5.
Enter
Market Share
in the
Label
input box.
6.
From the
Expressions
tab, enable both the
Relative
and the
Value on Data
Points
checkboxes.
7.
Click on
Finish
to create the pie chart.
The result should look like the following screenshot:
You will notice that this does not look like a pie chart at all. Maximizing the chart to
full screen does show the pie, but it is unusable this way. The reason for this is that
there are simply too many dimension values; with hundreds of airlines the chart
looks more like a candy-cane than a pie.