Cloudera Docs

Using correlation

On the Correlation tab you can calculate correlations between fields in your dataset. A correlation is a statistical measure of how closely two variables move together (positive, negative, or no correlation).

Enable data profiling in Site Settings > Data > Enable Data Profiling. For more information, see Managing data-related site settings.

  1. Click DATA on the main navigation bar.
    The Data view appears, open on the Datasets tab.
  2. Find the dataset that you want to profile, either by scrolling through the list or using the search function.
  3. Click the dataset you want to examine.
    The dataset side navigation pane opens for the selected dataset, displaying the Dataset Detail page.
  4. Click Dataset Profiling in the left navigation panel.
    The Dataset Profiling view opens on the Profiling tab.
  5. Switch to the Correlation tab.
  6. Select the fields that you want to calculate correlation for and click Correlate to run the calculation.

    • Dimension: You choose one categorical or grouping variable.

    • Measures: You choose one or more numeric metrics you want to check correlation against.

    The correlation results are displayed.

    If the query is running too long, you can cancel it by clicking Stop.

    You can rerun a query and get updated results by clicking Refresh.