Databases Reference
In-Depth Information
Figure 2-12.
Define the chart attributes
Previously, we defined how the chart would look, but we didn't define the source of the chart yet.
What data does the chart need to show? You'll need to add a SQL query that will be used to feed the chart
with data (Figure 2-13). The SQL query syntax varies depending on the chart type you select.
Most of the charts have a query like this:
select link, label, value
from table
order by label
where
•
link
is a URL.
label
is the text that displays in the chart.
•
value
is the numeric column that defines the size of the chart type.
•
