Example of a Horizontal Bar Chart SQL Template: Host CPU Performance
From the SQL Template Designer tabbed window, select and .
Select and click at the bottom of the Query window.
Enter the heading for the drop-down list in the Static Custom Combo box--for this example,
Enter the following comma-separated list of values and then click :
These will be the options that a user can select when generating a report.
Click on the tab and enter the following query:
SELECT trunc(log_date,DECODE('${freeCombo1}','Hour','HH24','Day', 'DD','Week','WW','Month','MM', 'Quarter','Q','Year')) the_date, avg(system_processing_time_pct) avg_system, avg(user_processing_time_pct) avg_user, max(system_processing_time_pct) max_system FROM apt_v_host_cpu_log WHERE log_date between ${startDate} AND ${endDate} GROUP BY trunc(log_date,DECODE('${freeCombo1}','Hour','HH24','Day', 'DD','Week','WW','Month','MM', 'Quarter','Q','Year'))Click and then .
In the Formatting window, select and set the Caption field to with the Axis label set to
Check all four fields: and
One by one, select the bar fields, and , and click the Formatting button (at the bottom of the window) to configure the color of the bar. And, enter a relevant label for each field.
Select the max_system field and click the Formatting button (at the bottom of the window) to configure the color of the line.
Save the report to a report menu group. Then, click the saved report to generate it.
The output for the horizontal bar chart will look something like this:
