Use Advanced Analytics Functions

Advanced analytics are statistical functions that you apply to enhance the data displayed in visualizations.

The Analytics area in the Data Panel contains standard analytics functions (for example, Clusters and Trend Line). You can use analytics functions as they are, or use them to create your own calculated columns that reference statistical scripts.

Add Advanced Analytics Functions to Visualizations

You can apply advanced analytics functions to your project's visualizations.

Before you can use analytic functions in visualizations, you must do the following:

  • Install DVML.

    On Windows go to Start, browse to and expand your system's Oracle folder, and click Install DVML.

    On Mac, go to Applications and click Oracle Analytics Desktop Configure Python.

  • Create a project or visualization that you can apply one or more analytic functions to.

  1. Confirm that you’re working in the Visualize canvas.
  2. To display the available advanced analytic functions, click the Analytics icon in the Data Panel.
  3. To edit the applied advanced analytics in a visualization, highlight the visualization, and in the properties pane click the Analytics icon.
  4. To add advanced analytic functions to a visualization, do one of the following:
    • Drag and drop an advanced analytic function (such as Clusters, Outliers, Reference Line) from the Analytics pane to a visualization.
    • Right-click a visualization, and select an advanced analytic function.
    • In the properties pane select the Analytics icon and click Add (+), then select a function such as Add Clusters or Add Outliers.

Add Reference Lines to Visualizations

You can use advanced analytics reference lines to identify the range of data element values in a visualization.

  1. Confirm that you’re working on the Visualize canvas.
  2. In the Data Panel, click the Analytics icon.
  3. Drag and drop Reference Line into a visualization. Alternatively, you can double-click Reference Line to add it to the selected visualization.
  4. In the properties pane select the Analytics tab and do the following:
    1. Click the current Method and select Line or Band.
    2. Click the current reference Function (for example, Average and Custom) and select the reference function that you want to use.
    3. If you choose the Line method, you can select reference functions such as Median, Percentile, Top N, and Constant.
      • Percentile - Percentile rank number ranks the percentile of the data element added to the visualization.
      • Top N - N value marks the highest values (ranked from highest to lowest) of the data element added to the visualization.
      • Bottom N - N value marks the lowest values (ranked from highest to lowest) of the data element added to the visualization.
    4. If you choose the Band method, you can select either Custom or Standard Deviation as the reference function.
      • Custom - Select the to and from range of the data element values (such as Median to Average).
      • Standard Deviation - Select a value from 1 to 3 to show the standard deviation for the selected value of the data element.
  5. Click Save.
Based on the selected Method or reference Function, a line is displayed in the visualization to highlight the value.