Add Statistical Analytics to Visualizations

Statistical analytics enable you to highlight clusters or outliers, add forecasts, and show trend and reference lines in your workbooks. Select them on the Analytics tab of the Data pane in the workbook editor.

Alternatively, you can add forecasts, trendlines, and clusters to a workbook using text-only analytics functions. See Analytics Functions.

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 workbook or visualization that you can apply one or more analytic functions to.

Before you start, make sure that you have the required data in your visualization for the type of analytics you want to add. For example, for a forecast, you need at least one time dimension and a measure or metric.
  1. On the Home page, hover over a workbook, click Actions, then select Open.
  2. In the Data Panel, click the Analytics iconUse the Analytics icon on the Data pane or Properties pane to view statistical analytics available..
    Description of stat_analytics-png.png follows
    Description of the illustration stat_analytics-png.png

  3. Drag and drop Cluster or Outlier from the Analytics pane to a visualization.
  4. To configure the analytics function click Properties on the Grammar Panel and use the options in the Analytics pane.
You can also access the analytics options by right-clicking on a visualization, and selecting Add Statistics.
Description of stat-analytics2-png.png follows
Description of the illustration stat-analytics2-png.png