Summary Level Option

Check out the given illustration on how to create a Formula Field at the Summary level.

Formula filed creation at Summary Level

The user can also create a formula field choosing the Summary Level as a level option from the Formula field editor window.

• Access the Create Calculated Field window.

• Navigate to the Formula tab (It is the default tab).

• Give a name to the new field.

• Choose Summary Level from the Level drop-down menu.

• Select a Save as option (It allows only Measure as the Save As option).

• Enter a Formula Expression using the Fields and Operators.

• Click the SAVE option.

Creating Formula Field at the Summary Level

• A new Formula Field gets created and added to the list of dimensions and measures.

Please Note:

• The Summary level Formula Field only gets saved as a Measure. It can't be saved as a Dimension to the Data Store.

• Summary Level will not be listed for the space where the MongoDB server is configured in the Admin Settings.