Strategy One

Create Custom Subtotals

Custom subtotals offer a way to define aggregations that suit specific business requirements, other than the out-of-the-box options such as Sum, Average, Mean, etc.

To use, create, and edit subtotals, you must have at least one the following privileges:

  • Client-Web: Web use metric editor

  • Server-Intelligence: Create application objects

  1. In the Navigation pane, click Objects.

  2. In the top right corner, click Create New Object.
  3. In the Create New window, if you are connected to multiple projects, select the project from the drop-down list on the left.
  4. Click Subtotal.

  5. On the Functions tab, double-click a function to add it to the Formula Editor.

    You can also add a function by hovering over it and clicking Add with Details. The corresponding dialog provides additional guidance for modifying the function parameters prior to modifying the formula.

  6. Select the Object Browser tab to add objects from your project.

  7. Build your formula and Validate it when you are finished. Remember that x is the placeholder for the metric to be subtotaled in your report.

  8. Once you have validated your formula, you can enable Show Function Parameters to view and modify the parameters.

  9. Expand the subtotal in the Summary pane to see the Group By level.

  10. Assign a Name to your custom subtotal.

  11. Click Save.