From the SQL Template Designer tabbed window, select Date Range and Host Groups and Client Scope.

Select Static Custom Combo Box and click Configure at the bottom of the Query window.

Enter the heading for the drop-down list in the Static Custom Combo box--for this example, Group by:

Enter the following comma-separated list of values and then click OK:

Hour,Day,Week,Month,Quarter,Year

These will be the options that a user can select when generating a report.

Click on the Query 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 Validate Query and then Next.

In the Formatting window, select Stacked Barand set the Caption field to the_date with the Axis label set to CPU Utilization%. To create a Dynamic Stacked Bar chart, select the Caption field and choose a different String field as a Legend. Legend can be selected from the Formatter.

Check all four fields: the_date, avg_system, avg_user, and max_system.

One by one, select the bar fields, avg_system and avg_user, 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 on the saved report to generate it.