Analyze Functional Dependencies Using the Tree View

Use the tree view when you have a small number of functional dependencies to analyze.

To analyze the functional dependencies of the data in your worksheet:

  1. Open the worksheet you want to analyze.
  2. Select the Functional Dependencies icon in the top left corner above your worksheet.
  3. If the sunburst view appears, click the tree icon in the lower left.
    The tree view shows the following:

    • The root node represents the worksheet.

      When you click on the root node, the right side panel shows the worksheet properties.

    • The next two sets of nodes represent the functional dependencies between pairs of columns.

      The left nodes represent columns that determine the corresponding values of columns on the right side.

    • The colored lines between columns represent functional dependencies. The shades of green to orange indicates how well the values comply with the implied dependency.

      The darker the green is, the more the values comply and the less the values violate the dependency.

  4. Click a line in the tree view to display the following details in the right side panel:

    • Circle diagram that indicates the exact percentage of compliant rows and violating rows

    • Function that represents the dependency between the two columns if the application is able to detect it.

    • Bar graph that shows the conflicting values for the selected functional dependency.

      For each occurrence of a unique value in column A, column B should have the same value. Violations occur when multiple occurrences of a distinct value in column A appears with different values in column B.

  5. If you want to see functional dependencies that are statistically unlikely or impossible to encounter conflicts, select the Include trivial option.
    Trivial functional dependencies include the following:

    • Columns on the left side contain only unique values.

      For example, a unique ID column does not have multiple occurrences of the same value; therefore, no conflicting values can occur on the right side.

    • Column B values are calculated by a formula on column A.

  6. If you want to filter the number of functional dependencies that appear in the diagram, move the Violations slider to specify the percentage of violating values you want to allow in your view.

You can now go back to your worksheet to resolve some of the conflicting values by using actions such as Harmonize Values.