1. User’s Guide for Oracle Analytics Desktop
  2. Visualize and Analyze Data
  3. Use Calculations in Workbooks
  4. Tips on Using Calculations

Tips on Using Calculations

Use these tips to help you create calculations in a workbook.

  • Calculations are stored in the My Calculations area of the Data Panel, where you can reuse them in any visualization in the workbook. For example, if you have data elements for height and width, you might calculate area by multiplying height by width (that is, height * width). You can reuse the area calculation in other visualizations in a workbook. You can also use calculations in other calculations.
  • In the workbook editor, review existing calculations in the My Calculations area, and select a calculation to display its attributes in the Data Panel.
    Description of my-calculations-1.png follows
    Description of the illustration my-calculations-1.png

  • To add a calculation to a visualization, drag it from the My Calculations area to the visualization or Grammar Panel.
    Description of my-calculations-2.png follows
    Description of the illustration my-calculations-2.png

  • Right-click a calculation to its editing options. For example, you might add it to the selected visualization, use it to filter your data, or let Oracle Analytics choose the best visualization type for you (that is, Create Best Visualization).
    Description of my-calculations-3.png follows
    Description of the illustration my-calculations-3.png

  • To calculate a new value to use in your workbook, click Add, then Calculation to display the New Calculation dialog, where you can specify the details (for example, height * width). The new calculation is added to the My Calculations area.
    Description of my-calculations-4.png follows
    Description of the illustration my-calculations-4.png