Database Reference
In-Depth Information
F I g u R e 13-33
Choosing a metric
Click on the table on the left (The table and not the chart you edited above),
and add a filter to show GDP per hour worked; then add another table below
it by dragging value onto the white space. Add a country name and a filter
to show average hours actually worked. These tables will all then be sliced
by the chart. Each table and chart will be filtered by a different metric value.
Finish by dragging value to the whitespace beneath the chart. You may need
to clear some space, which you can do by selecting the corner of the title text
box, deleting it, and then resizing the main box. Drag Metric onto this new
table; filter by the three metrics GDP per hour worked, GDP per capita, and
Average hours actually worked; and then change it to a column chart. Move
Metric to Legend, and drag YearNumber to the Axis of the chart. This will
give you an interactive dashboard similar to the one in Figure 13-34. Clicking
either of the charts will update the other chart with that selection, as well as
the tables.
