Using the Drill-Down Wizard

Use the GainSeeker Drill-Down Wizard to discover the most likely items on which to drill into on a Pareto chart to discover the root causes of variation in your processes.

 

Contents  [Hide]

 

Opening the Drill-Down Wizard

To ensure accuracy, remove any known special cause data before using the Drill-Down Wizard.

There are three ways to open the Drill-Down Wizard from a Pareto chart:

Tip: If you already know into which Pareto charts bars you want to drill, you can right-click a Pareto chart bar, and then select Drill Down... on the right-click menu that displays. For more information, see Drill down to the root cause on a Pareto chart bar

Step 1

On Step 1, you can select the traceability values used for the analysis and the maximum cumulative and minimum percentages for traceability items that will display on the list.

Tip: You can press the F1 key any time you are using the Drill-Down Wizard to open this help topic for reference.

Select the traceability values for the analysis

Select the largest defect categories to analyze

Decreasing the maximum cumulative percentage and increasing the minimum percentage will reduce the number of items that display in the traceability list in Step 2. After making all selections, click Next > to proceed to Step 2.

Step 2

Step 2 of the Drill-Down Wizard displays the analysis for each of the traceability values you selected in Step 1.

The results are sorted by the highest percentage of defects for each traceability and category. You will usually want to select items with the highest percentage for further analysis. In some cases, the results may be expected, so they can be ignored. An example of this would be when 50% of the results are from Shift 1 and 50% from Shift 2 when you are analyzing only two shifts.

You can click a row in the Drill-down results list to view the explanation for it near the bottom of the wizard.

Next, you can opt to click Next, Drill down, or New Chart.

To draw a chart that uses all of the categories for the selected traceability:

To draw a chart for a subset of the current data, which contains only the selected traceability category:

If you opt to drill-down into the listed Existing conditions (Shift 1 in this example) by Department, the following chart would display, which shows most of the defects in Shift 1 occurring in the Printing department.

Note that the Pareto bars for this new chart are red in this example whereas on the previous chart they were blue. The change in bar color for each new chart can help you to identify your current level in the drill-down analysis. See Colors that identify drill-down levels

To display the highest percentages of the drill-down selections for the traceability value to be displayed on Step 3:

Step 3

Step 3 displays the drill-down results of all the selected traceability values for your data. These are sorted according to the percentage of defects that were found for the traceability and the category displayed.

To display a new chart for the selected traceability values from Step 2:

To draw a chart for a subset of the current data that contains only the selected traceability category:

Related Topics