Working with the SQL Template Designer > Configure an Area Chart SQL Template
  
Version 10.1.01
Configure an Area Chart SQL Template
An area chart depicts a time-series relationship. Unlike line charts, area charts can also visually represent volume. Information is graphed on two axes, using data points connected by line segments. Basic area charts depict the data using transparency to overlay the areas. Stacked area charts presents the data areas without overlaying - displaying part-to-whole relations by showing the constituent parts of a whole one over the other. See also:
Configure SQL Template Scope Selector Components
Construct the SQL Query
Number, Size, Date, and Time Formatting
Format the SQL Template Output
Example of Area Chart SQL Template: Allocated Available
1. From the Template Designer tab, click Query custom combo box.
2. With the Query custom combo box selected, click Configure.
3. In the Heading field, enter the heading that will display in the report template’s scope selector drop-down list. For example Array Vendor.
4. In the Query field, enter the SQL query that returns a list of values that will be available in the combo box:
SELECT DISTINCT vendor_name,vendor_name FROM aps_v_storage_array UNION ALL SELECT ' All', ' All' FROM dual ORDER BY 1
5. Click Validate and OK.
6. Click the Query tab and enter the following. This query will use the value selected in the populated combo box to retrieve the data to be rendered in the report. The custom combo variable is represented as ${queryCombo1} in the query.
SELECT
Array_name,
allocated_gb, available_gb
FROM aps_v_storage_array
WHERE
'${queryCombo1}' IN
CASE
WHEN '${queryCombo1}' NOT IN (' All') THEN
CASE
WHEN vendor_name = '${queryCombo1}' THEN '${queryCombo1}'
END
ELSE ' All'
END
ORDER BY available_gb DESC
 
7. Click the Formatting tab.
8. In the Formatting window, select Area Chart or Stacked Area Chart from the Display the report as a drop-down list.
9. For the Caption field, select array_name from the drop-down list.
10. Select all the fields to be displayed.
11. Assign a color to each field that will be displayed as an area. In the example, assign a color to the fields allocated_gb and available_gb.
12. Assign a name for the report template and save it to a report menu group. You can also assign sharing if required.
13. Generate a report from the new template. The output will look similar to the following example: