Creating the Incident Day of Week Trend pod

This procedure contains steps and procedures for creating the Incident Day of Week Trend pod and includes the following:

• • • Creating the Incident Day of Week Trend View
    • Creating the pod

Creating the Incident Day of Week Trend View

We create the data view by clicking Data Views in the Pod Builder tool, clicking New on the Data View management dialog, specifying Incident Day of Week Trend as the data view name, then by making the following selections in the Data Set screen:

• The BMC Remedy AR System database schema name, in our case, ARADMIN.
• The table (view) that we created earlier when we prepared the data, INCIDENT_SUMMARY_DAILY.
• We select all of the columns in the table except for the TIMEZONE and TIMEZONE_ID columns.
• We apply the SUM function to the NUM_INCIDENTS column so that the Pod Builder can calculate the total number of incidents reported on a daily basis. The function name is prefixed to the column name, which is then used as the alias. In the example above, the NUM_INCIDENTS column is automatically assigned the alias SUM_NUM_INCIDENTS. You can keep this alias or update it.
• We apply the DAY_OF_WEEK function to the DATE_POINT column so that the Pod Builder can report the dates in a day of week format (Monday through Friday). The function name is prefixed to the column name, which is then used as the alias.

Creating the pod

This pod is created following the steps for the Incident Monthly Trend pod, but instead, we use the Incident Day Of Week Trend View data view and the DAY_OF_WEEK_DATE_POINT in the Select Data for the Chart dialog for the summary bar chart.

The Select Data for the Chart dialog is shown below:

(Click the image to expand it.)