Database Reference
In-Depth Information
Finally, in the bottom pane, the combination chart will be added.
16.
From the
To o l b o x
tab of the
Insertable Objects
pane, drag a
Chart
object into the
bottom table cell.
17.
In the
Chart Group
pane, select
Combination
.
18.
Click
OK
to accept the default Column chart and close the dialog box.
Figure 2.2 shows the work area for the report.
Figure 2.2
Initial dashboard design
Step 4: Set Up the Returned/Shipped Ratio Query
This query will retrieve the quantity sold and quantity returned for each country in order to calcu-
late the ratio of items returned to items sold. This will be displayed on the dashboard's map.
After we added the three data containers to the dashboard, three new queries were created
for each of them. In the next three steps, we will customize the queries that are associated with
each object.
1.
In the
Explorer Bar
, mouse over the
Query Explorer
tab and select the
Queries
folder.
2.
Rename
Query1
to
Returned/Shipped_Ratio_by_Country
.
3.
Double-click on the query to open the query definition.