Example of a Donut Chart SQL Template: NetBackup Job Size by Job Type
The following example results in a donut chart that represents the various job types--such as, application backups, full backups, incremental backups, and restores--as segments in a donut chart.
In the SQL Template Designer, do not check any Template Designer items.
In the Query window, enter the following select statement and click :
SELECT job_type_name, sum(kilobytes/1024/1024) Job_SIZE_GB FROM APT_V_NBU_JOB_DETAIL WHERE finish_date > sysdate -7 AND job_type_name IS NOT NULL GROUP BY job_type_name ORDER BY job_type_name
In the Formatting window, select from the Display report asdrop-down list.
For the Caption field, select from the drop-down list.
Select all the fields to be displayed.
For a donut chart, you need at least one field to be the caption and another field to be the segment.
Click , enter a report name and Menu Group. Then, click .
When you run this report, the output will look something like this: