Example 4: Drawing a Gauge Chart

Draw a chart to show the number of pending CAPAs, knowing that the minimum number of pending CAPAs can be 0 and does not exceed 100. The chart must reflect the following details:

If you have 0–55 pending CAPAs, then the system status will be “Acceptable”. If you leave the minimum value field empty, its value will be inherited from the minimum scale value field, which is 0.

If you have 56–85 pending CAPAs, then the system status will be “Warning”. An investigation must be carried out to identify the problems.

If you have 86–100 pending CAPAs, then the system status will be in danger and immediate action must be taken. If you leave the maximum value field empty, its value will be inherited from the maximum scale value field, which is 100.

To create a chart with the above details, follow the steps below.

1. Create a new chart template and specify a suitable title (e.g., Number of Open CAPAs), then set the chart type to Gauge. The template will refresh to display the fields and sections that are related to the gauge chart.
2. Select the 1. Corrective Actions\ 1. Open : by Assigned view from the view field.
3. Set 0 in the Minimum Scale Value field and 100 in the Maximum Scale Value field.
4. Select the Count value from the value field. Remember that this field is set to accept a single value when the chart type is gauge.
5. Keep the default  Aggregation value.
6. Add three records to the Gauge Color Ranges subform and fill them out with the information in the following table:

1. Save the Chart Template and then, click on the Preview Chart button.

The chart will be drawn as in the figure below.

 

Gauge Chart Elements:

The figure above shows the following elements of the Gauge chart:

Radial Scale: Displays the range values. If the chart’s current value exceeds the maximum scale value, then the scale is adjusted to show that value as the maximum value of its range. The same applies to the minimum value. For instance, if a chart has 0 as a Minimum Chart Value and 40 as a Maximum Chart Value with no color ranges, but one of the values is 45, the chart will appear as in the figure below.

Color Ranges: Color ranges are sections that have different colors to reflect a specific description.

If you leave the Minimum Value field of the first record in the Gauge Color Ranges subform record empty, then its color will be extended backward within the gauge chart to match either the minimum scale or the chart result, if it is less than the minimum scale.

If you leave the Maximum Value field of the last range record empty, its color will be extended forward within the gauge chart to match either the maximum scale or chart result if it is more than the maximum scale.

Needle: The needle points to the current value of the value field. Notice that the needle color will change to the color of the range of the reading value.

Digital Panel: Displays numeric values on the radial scale.

Gauge charts have no legend. The gauge needle is the only clickable part of the chart.

 

Filter Charted Data

The Chart Template tab also includes the Enable Filters checkbox. This option will display the Filter Condition, Date Range Filter, and Locations Filter subforms through which you can the chart filters. The Show Filters Description in the Chart Image checkbox will be displayed and enabled by default, to show a description of the applied filters at the top of the generated chart.

 

Filter Condition

Use the  Filter Condition subform to filter the records based on a specific field (e.g., Phase, Number…). You can use more than one record and combine them using the Logical Operator field which values are: AND and OR.

To Set a Filter Condition:

1. Select the field of the records that will be filtered from the Field Name list. Note that if you are getting your data from a certain view, all the view columns will be displayed except the dates columns, which can be filtered using the Date Range Filter section.
2. Select the operator that determines how the records will be filtered from the Comparison Operator list.
3. Enter the value of your selection in the Value field. When setting filters for number fields, it is not recommended to use the Contains/Does not Contain comparison operators, as these operators will not retrieve the numbers that partially match the specified value. For instance, filtering for any figure that contains 50 will not retrieve 500 or 150 and so on.

 

To set another Filter Condition:

1. Add a new record. The Logical Operator field will be displayed once you add a record to the subform.
2. From the Logical Operator field, select the operator that will combine two filters. You can select one of the following two operators:

AND: This operator includes a record in the chart if both the first condition and the second condition are true. This means that only the documents that meet the two filtering criteria will be included in the chart.

OR: This operator means that any document that meets at least one filtering criteria will be included in the chart.

1. Fill in the Field Name, Comparison Operator, and Value fields for the second filter as explained above.
2. Click on the Preview Chart button to view the filtered data.

 

Example 5: Setting a filter condition

To set the filter to display only the documents in the draft phase, fill in the filters section as shown in the figure below.

Example 6: Setting a filter using AND operator

To set the filter to display only procedure documents in the draft phase, fill in the filters section as shown in the table below.

 

Example 7: Setting a filter using AND and OR operators

When using both of these logical operators, keep in mind that the operator AND will always take precedence over the operator OR, (i.e., the filters combined with the 'AND' operator will be executed before the filters combined with the 'OR' operator). See the following example:

(Filter Record 1) AND (Filter Record 2) OR (Filter Record 3) AND (Filter Record 4)

Since AND takes precedence over OR, the filters will be executed in the following sequence:

[(Filter Record 1) AND (Filter Record 2)] OR [(Filter Record 3) AND (Filter Record 4)]

[Result of Filter 1 AND 2] OR [Result of Filter 3 AND 4]

Therefore, you should set your filters keeping in mind how these rules will affect your results.

For instance, assume that we have the following documents within the Document Control application:

Case 1: Show the procedure or form documents that are from NY.

This can be translated to the following statement:

(Location = NY AND Type = Procedure) OR (Location = NY AND Type = Form).

The table below shows how to set the filters.

 

The filtered documents are shown in the table below.

 

Below is the chart that is generated based on these filters. 

Note that the description of the applied filter appears at the top of the generated chart due to selecting the Show Filters Description in the Chart Image option within the Chart Information section.

Case 2: Show the procedure documents from NY and all of the form documents.

This can be translated to the following statement:

(Location = NY AND Type = Procedure) OR Type = Form.

The figure below shows how to set the filters.

 

The filtered documents are shown in the table below.

Below is the chart that is generated based on these filters. 

Example 8: Gauge Chart with Filter

Create a Gauge chart to show the number of pending CAPAs records in the Corrective Action application and apply a filter to get the pending CAPAs at the Initiate Phase and for the Engineering department. Follow the below steps to define the specification for the Gauge chart and filtration:

1. Create a new chart template and specify a suitable title (e.g., Number of pending CAPAs in the Initiate phase for Engineering) then, set the chart type to Gauge. The template will refresh and display the fields and sections that are related to the Gauge chart type only.
2. Select the Corrective Action (CAPA/SCAR) : 1. Corrective Actions\1. Open : by Assigned view from the View field.
3. Set 0 in the Minimum Scale Value field and 100 in the Maximum Scale Value field.
4. Select Count from the Value field.
5. Keep the default  Aggregation value.
6. In the Gauge Color Ranges subform click on the Add Records button.
7. The form is refreshed, and a new record is added to the subform.
8. Add two more records and populate the subform as shown in the table below.

1. Select the Enable Filters checkbox. The form is refreshed to display the filter sections.
2. Populate the Filter Condition section as shown in the figure below.

1. Save the template and click on the Preview Chart button. Below is the chart that is generated based on these filters. 

1. Click on the needle in the gauge chart to see the corresponding filtered data.

 

Set a Date Range Filter

Using the Date Range Filter subform, you can generate a chart with data for the last year, last month, or even a specific time span.

The Date Range Filter subform can be set by selecting the date to filter from the Field Name field and specifying the date range Criteria.

The Field Name lists all date filters that are available for the charted data.

After selecting the date filter, refresh or save the chart template to display date range fields with labels based on the date filter. The label options are listed below.

Date From, Date To; if the filter is Date.

Time From, Time To; if the filter is Time.

Date and Time From, Date and Time To; if the field’s type is Date and Time.

The date range filter fields can be automatically or manually populated based on the specified Criteria. The criteria list contains the most common time spans, which are explained in the table below.

Although the Date Range fields in the chart template are populated with static date values that are set to the date on which the chart template was created, the chart documents created accordingly will have the Date Range fields filled according to the specified date criteria, but with instantly updated date values.

 

Set a Location Filter

The Location Filter enables you to filter the charted data according to the location(s) in the chart template or in the generated chart documents in different ways.

For example, if our chart template is set to chart the number of complaint records in the draft phase, and we have 10 draft complaints at the USA : New York location and 5 draft complaints at the USA : Los Angeles location, then the chart will return the =numbers of draft complaints in the chart template and chart document. The filtered documents are shown in the table below.

Specify the filter option as either the document location alone or the location with lower, higher, or both locations.

Notice that selecting the All Document Location(s) (No Filter) option does not apply a location filter on the charted data.

The filter options will be transferred automatically to the generated chart documents and may be edited. You can select the Prevent modifications of these options in chart documents created from this template option to disable changing the location(s) filtering options in the generated chart document.

Make sure that the filter options defined for the selected view match the location(s) filters.

 

Draw Lower/ Upper Control Limits (LCL/UCL)

Select the Enable Lower/Upper Control Limits (LCL/UCL) checkbox if you want to draw the lower and upper control limits. By selecting this checkbox, the LCL/UCL Calculation section will be displayed. Notice that this checkbox will only be displayed for certain views and if the chart is either Bar, Column, Column & Lines, Line or Pareto, Stacked Bar, Stacked Column.

The LCL/UCL Calculation section will assist you in drawing the lower and upper control limits that indicate graphically whether the data is within or out of the control limits. This statistical model allows for rapid analysis and intervention for active processes. 

Calculation Types: You can calculate the control limits manually based on your input or automatically based on a formula.

Manual: If you want to calculate the control limits based on your defined UCL / LCL values, then keep this option selected and populate the fields.

LCL Title: Enter the title of the LCL line. The default value for this field is LCL.

LCL Value: Enter the value of the lower limit that you want the samples to be evaluated against.

Average Title: Enter the title of the average line. The default value for this field is Average.

Average Value: Enter the average value you want the samples to be evaluated against. Note that if you leave this field empty, the average line will be hidden.

UCL Title: Enter the title of the UCL line. The default value of this field is UCL.

UCL Value: Enter the value of the upper limit that you want the samples to be to evaluated against.

Keep in mind that if the value of the LCL exceeds the value of the UCL a validation message will be displayed.

Calculated: If you want to calculate the control limits based on the formula LCL/UCL = C +/- 3 SQRT(C), then select this option and specify the following options:

Display Lines: Select which limit lines to display on the chart including LCL (Lower Control Limit), Average, and UCL (Upper Control Limit).

Period to use: Select one of the following date period to use:

Last Calendar Year: For this option the mean will be calculated starting from the beginning of the last year. E.g., today is August 12, 2012 so the mean should be calculated from the beginning of 2011 to today’s date.

Year-to-Date: For this option the mean will be calculated starting from exactly one year prior to the current date. E.g., today is August 12, 2012 so the mean should be calculated from August 11, 2011 to August 12, 2012.

Specific Period: For this option the mean will be calculated for a specific period of time. If selected the date from and date to fields will be displayed, allowing you to enter the appropriate time period. 

Date Field:  This displays all of the date and date and time fields for the parent form. Select the field to use the calculation based.

LCL Title: This is where you enter the title of the LCL line. The default LCL Title is LCL.

Average Title: This is where you enter the title of the average line. The default Average Title is Average.

UCL Title: This is where you enter the title of the UCL line. The default UCL Title is UCL.

Keep in mind that negative LCL, UCL, and average values will round up to zero.

 

Set Chart Document Location Options

The Chart Document Location Options section gives you different options to secure chart documents by setting a default value in their Location(s) fields. This is beneficial when a location filter is applied to the chart template/document. Location filters are enabled using the previously explained Location Filter section.

After changing the Chart Document Location Options, you will need to save the chart template for the selected option to become effective.

There are three options to set a default location for the chart documents:

Document location will match the user’s primary location: Selecting this option will set the Location(s) field within a created Chart Document dynamically according to the primary location of the user who has created it.

Note that the document location will match the user’s location. A location cannot be selected when scheduled reports are enabled within the Scheduled Reports tab of the Chart Template. This is because scheduled reports are always created by the system user which has no location.

Document location will match the Chart Template’s locations: Selecting this option will copy and transfer the location(s) in the chart template to the related chart documents.

Document location will match the selected locations: When this option is selected the chart template will refresh to show the selected locations, which includes all of the locations defined in the platform. When the location is set, the location(s) will be transferred to the field of created chart documents; regardless of the creator or chart template location.

 

Enable Scale Options

This option is displayed when the Category (X Axis) field has a date field. It is used to set an X-Axis scale for the charted values.

To use this option:

1. Make sure that the Category (X Axis) field has a date field.
2. Select the Enable Scale Options checkbox. This will display the Scale Option section with the date field set in read-only mode in the Category (X Axis) Scale field and the editable From and To fields.
3. Set the From and To fields with the date range you want to define the X-axis scale start and end.

The below figure demonstrates the number of pending documents when the Enable Scale Options checkbox NOT selected:

When the Enable Scale Options checkbox is selected, and the dates in the Scale Options section specified from Feb 1st to Feb 28th the diagram will be displayed as below:

 

Customize Chart Colors

Using default Centralized Reporting charting colors might not reflect the business colors of what is charted. For instance, it is common to use red for high-risk items; however, the Centralized Reporting charts sometimes use green.

The customize colors option allows you to reflect business color themes in the charts for the secondary\primary y axis values. However, when a compare-to value is set, chart color customization can only be set according to the compare to value.

For a better understanding of how chart colors can be customized, review the examples below.

Example 9: Customizing the Colors of Secondary\Primary Y Axis’s Values

The Corrective Action (CAPA/SCAR) : 1. Corrective Actions\6. Reports\Charting Views : Cost by Department (CAPA/SCAR) view of the Corrective Action and Preventive Action (CAPA) application charts the data along with the departments by their costs.

Chart Template: CAPA by Department vs. Costs

Chart Type: Column

Description: This chart shows departments and their costs for each CAPA record.

Use: View

View: Corrective Action (CAPA/SCAR) : 1. Corrective Actions\6. Reports\Charting Views : Cost by Department (CAPA/SCAR)

Category (X Axis): Department

Values (Primary Y Axis): Materials, Labor, Administrative

Once the template is complete, a chart will be generated as is shown in the figure below.

 

As you can see in the above figure, the cost for Materials  presented in Blue, Labor  presented in Red and Administrative presented in Orange.

The colors of the charted values can be customized by selecting the Customize Colors option. To change the colors so that the cost for Materials presented in Red, Labor presented in Orange, and Administrative presented in Green. In this case, the Chart Template will refresh to display the Customize Colors section with the Color Column Values subform, which contains a record for each value selected (primary or secondary).

This form allows you to set a color for each value in the chart. In our example, notice the colors set in the image. Once the template is complete, a chart with customized colors will be generated as shown in the figure below.

 

Example 10: Customizing the chart colors according to the Compare To value:

For each document listed, the Document Control: 1. Pending Documents: by Department view of Document Control application shows the Location, Department, Type and other information.

If this view is used to chart the pending documents by Location compared to their Department a chart template will open.

Once the template is complete, a chart will be generated as is shown in the figure below.

 

As you can see in the above chart, the pending documents are presented in the default colors: Blue for Administration, Red for Engineering, and Yellow for Manufacturing.

In order to customize colors on your chart instead of the default ones, select the customize colors option, which will refresh the chart template and display the Customize Colors section.

To define colors for specific department, select the Define Colors option. The Customize Colors section will refresh to display a subform with the following two fields: Compare To Value and Color.  The Compare To Value field of this subform is case-sensitive. To change the colors so that the cost for Administration presented in Yellow, Engineering presented in Orange, and Manufacturing presented in Blue.

Once the Customize Colors section is filled in, click on the Preview Chart button to view the color customization in the chart. The figure below shows the chart for this example.

 

 

Example 11: Defining Colors for the Compare To Values Based on a Specific View-Column of Color Type.

The Corrective Action (CAPA/SCAR) : 1. Corrective Actions\1. Open : by Priority view of the Corrective Action application shows the Number, Due Date, Phase, Department, Priority, Location for each CAPA document. The priority color is created based on the color indicated in the priority color field which can be added to the CAPA.

For more information about defining color fields and color view columns, refer to the online help for field setting and column setting.

This view is used to chart the open CAPAs by department compared to priorities.

Once the template is complete, CAPA priorities will be presented in the default colors as shown in the figure below.

 

The document priorities for the open CAPAs are presented using the above colors.

To use the customize colors displayed in the priority color column on your chart instead of the default ones, first select the Customize Colors option. Then, in the Customize Colors section, select the Define Colors using View Column option. In this case, the Color Column field will be displayed listing all color columns available in the chart. In our example, this field will include the Priority color column.

Once the Customize Colors section is complete, click on the Preview Chart button to view the customized colors on the chart as shown in the figure below.

 

 

Enable Scheduled Reports

The scheduled reports tab is specially designed to schedule the process of creating the charts.

When scheduled reports are enabled, the location of the chart documents cannot match the user location. Scheduled reports are always created with system user that has no location.

To enable scheduled reports, select the enable scheduled reports box and fill in the following fields.

Every (in days) / For (in days): Use these fields to set the rate of recurrence at which the chart will be automatically created. For example, the above figure shows that the chart is scheduled to be created every 2 days for 100 days.

A task profile is available to control the scheduled charts. Task profiles are used to define and schedule a task according to the timing that you specify in the frequency field.

Online Distribution List: Select the users whom you would like to notify about the creation of a chart.

Notification Email Subject: Two options are available to create the notification email subject: EtQScript or Expression Builder.

When EtQScript is selected, a default script will be displayed for the subject of the e-mail. However, you can change or modify the script to meet your needs.

If Expression Builder is selected (default), you can specify the subject of the e-mail. You may customize the email subject by adding values using Insert field value.

Insert field value: This lists all fields that are available in the chart.

To customize the notification subject:

In the Notification Email Subject field, select the Expression Builder option and click on the Open Expression Builder button.

Place the cursor where you wish to insert the field’s value. (E.g., at the end of the sentence)

From the insert field value options, select the value you would like to display.

The field description will be added where the cursor is placed in the following format:

{etqfield:[Field Design Name] – Form (or Subform): Parent Form Design Name]}

Notification Email Body: Two options are available for notification email body: EtQScript or Expression Builder.

If EtQScript is selected, a default script will be displayed for the body of the e-mail notification. You can change or modify the script to fit your needs.

If Expression Builder is selected (default), you can specify the body of the e-mail notification. You may customize the email body by adding field values using the insert field value option.

Insert field value: This lists all fields that are available in the chart. To customize the body, apply the steps listed above for subject customization.

 

Drill Down through a Multi-Category Chart

Selecting more than one column in the categories (x axis) field will cause the chart to be organized in levels that provide a practical overview for users. To view the chart of any category, click on its related data. Typically, the chart levels will be sorted based on the order of the selected categories. Click on the last level of the graph to see its related view. Keep in mind that you will no longer have the ability to drill down to the related view after saving the chart document, nor you will you be able to drill down to the line series in a Pareto chart.

Example 12: Drill down through two categories

The Document Control : 1. Pending Documents : by Assigned  view in the document control application includes the documents listed below. 

Select the Phase and Type in the Categories (X Axis) field.

Select the Count value in the Values (Primary Y Axis) field.

Select the Due Date in the Compare To field.

Set the Day option in the Group Date by field.

Set the Sort Order field to No Sorting.

The chart will be generated as shown in the figure below.

 

The chart report summarizes the chart data, as shown in the figure below.

Remember that the ratio is not calculated for negative value categories. You can also select the Hide Total or Average box in the chart template and chart document to hide the total/average row from the chart report if this row does not have any business value.

Click on the draft column in the chart area to drill down to the draft documents. The following will occur as a result:

The documents that are in the draft phase will be charted.

The second value specified in the Categories (X Axis) field will be used.

The chart will be re-charted as is shown in the figure below.

 

The chart report will summarize the chart data as shown in the figure below.

Click on the procedure column in the chart area to drill down to the procedure documents that are in the draft phase.

 

Chart Template Views

The chart templates that are available in the Centralized Reporting application under 1. Charts\ 1. Templates view category are sorted by Creator, Data Source, Date, Disabled, Homepage Profile, Title, Type, View.

 

Chart Documents

You can crate a Chart Document from a Chart Template to save a The chart documents are created based on the chart templates. These charts display the data in a chart.

Create a Chart Document

You can create a Chart Document from a chart template by clicking the Create Chart Document button.

 

Chart Document Contents

The Chart Document tab is specially designed to display the data that you wish to include in the chart. The values are inherited from the chart template and will appear in edit mode.

You can change some of the fields in the created document as you need, before you save.

After changing any of the options, click on the Recreate Chart button to refresh the chart. The zoom options, Export Report to Excel button, and the chart report will be displayed at the bottom of the chart as shown in the figure below.

 

Chart Document Views

The chart documents that are available in the Centralized Reporting application under 1. Charts\ 2. Charts view category and are sorted by Creator, Data Source, Date, Title, Type, View.