Configure a Line Chart SQL Template
Line charts provide an effective way to visualize metrics on a time line. These charts are particularly useful for performance metrics, where you want to compare multiple metrics to assess historical performance.
The following example illustrates a simple bar chart.
From the Template Designer tabbed window, select Data Range and Array Scope Selector.
Create a query:
select storage_array_id, array_name, storage_pool_name, max(used_capacity_kb/1024/0124) used_gb, trunc(log_date) log_date from aps_v_storage_pool_log where storage_array_id IN (${arrays}) and log_date BETWEEN ${startDate} AND ${endDate} group by storage_array_id, array_name, storage_pool_name, trunc(log_date)Validate the query.
In the Formatting tabbed section, choose to display the report as a Line Chart and the select log_date as the Caption field.
Expectation for the legend is that only three fields are enabled for the formatter. One should be the Legend, next one should be the data and the last one should be a date.
Note:
If there are more than 3 fields, you need to uncheck them.
Select select storage_pool_name, used_gb and log_date.
For storage_pool_name select Legend as the Formatter.
Save the report. When you generate it from the Reports tab, the output will display something like this:
