Summary Level Option
Last updated
Last updated
Check out the given illustration on how to create a Formula Field at the 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.
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.