Duplicating and Editing Calculations

If you want multiple almost-identical calculations in your story, you can duplicate (copy) a calculation and then edit it in the Calculation Editor, just like you would edit any other existing calculation.

Context

There are times that you may want multiple calculations that are almost the same. For example, you want restricted measures with different time filters. It takes time to create a calculation and you have to create each calculation separately from start to finish, even if you only need to change one small parameter.

A faster way to create multiple calculations would be to duplicate an existing calculation and then edit it.

Note
Only the following calculations can be duplicated:
  • calculated measures
  • restricted measures
  • calculated dimensions
  • cross calculations

Procedure

  1. Use one of the following options to duplicate an existing calculation.
    • From a Chart:
      1. In the Builder, select a calculation.
      2. Select Start of the navigation path Next navigation step DuplicateEnd of the navigation path.
    • From a Table:
      1. In the Builder, expand the Story Calculations list. (Story Calculations are listed with measures or with cross calculations.)
      2. Select the calculation and then select (Duplicate calculation).
  2. Open the Calculation Editor for an existing calculation.
    • From a Chart:
      1. In the Builder, select a calculation.
      2. Select Start of the navigation path Next navigation step  Edit CalculationEnd of the navigation path.
    • From a Table:
      1. In the Builder, expand the Story Calculations list. (Story Calculations are listed with measures or with cross calculations.)
      2. Select the calculation and then select (Edit calculation).
  3. Make changes to the calculation.

    You cannot change the calculation type.

  4. Select OK.

Results

The table or chart is updated to reflect the edited results.
Related Information