Bar Chart Dynamic Template Step 3: Configure Functions for a Field
Each of the Summary Status fields require two functions:
DECODE, which detect and differentiate the status values, create counters for the status so that the number of backup jobs for the particular status can be tallied.
SUM, which sums the number of backup jobs per status.
In the selected fields panel, select the field that you've defined to represent the success status.
Click the button at the bottom of the panel.
In the Function Builder window, click .
Select from the drop-down list of functions.
Note that only functions relevant to the selected field will be available. The majority of these functions are Oracle functions that enable you to manipulate values.
In the Function window, two mandatory parameters and one optional parameters must be configured.
For the first Decimal, click in the Value cell and enter a . (Recall that in the description of this field, 0 = Success.)
For the second Decimal, click in the Value cell and enter a .
Click in the Optional Parameters section and enter a value of .
Click to save the DECODE function's configuration.
This configuration tells the system that whenever a zero is encountered for a job summary status, make it a 1 so that it can be added to the count of successful jobs; then, any other status will be set to 0 so that it will not get counted in this status.
Configure similar settings for the Warning Summary Status field:
For the first Decimal, click in the Value cell and enter a . (Recall that in the description of this field, 1= Warning.)
For the second Decimal, click in the Value cell and enter a .
Click in the Optional Parameters section and enter a value of .
Click to save the DECODE function's configuration.
Configure similar settings for the Failed Summary Status field, where the DECODE parameters will be , , .
For each Summary Status field, click and select .
