Creating and sorting table calculations

Centricity’s Explore page has a built-in Centricity expression editor to help you create table calculations, custom fields, and custom filters.

Before you create a table calculation, make sure that all the fields you want to use in the table calculation have been selected from the field picker, and that you have run the query.

There are two possible ways to access the Centricity expression editor from the Explore page, depending on whether your Centricity instance is enabled for custom fields.

Adding a table calculation without custom fields enabled

If your Centricity instance is not enabled for custom fields, click the Calculations button from the Data bar.

In the Edit Table Calculation pop-up, construct your custom metrics. The expression you create can evaluate to a number, date, string (text), or Boolean (true/false).

If you already have some table calculations defined, click the Add Table Calculation button to create another. You are able to add as many table calculations as you need.

Then, for each table calculation:

  1. Rename your table calculation from the default name, if desired.

  2. Optionally, click Default Formatting to choose a predefined format or create a custom format for the results. If you create a custom format, use Excel-style formatting. If no selection is made, Centricity uses a default format.

  3. Start typing a Centricity expression into the large text box to form your calculation. Centricity expressions can be quite simple, or they can use as many fields, functions, and operators as your business logic requires. The expression you create can evaluate to a number, date, string (text), or Boolean (true/false).

  4. If you are finished adding table calculations, click Save to add the calculation to the Explore.

Adding a table calculation with custom fields enabled

If your Centricity instance is enabled for custom fields and you have the permission to use them, open the Centricity expression editor with the following steps:

  1. Open the Custom Fields section of the field picker.

  2. Click New. If your admin has enabled the Upgraded Explore Field Picker Labs feature, click Add.

  3. Select Table Calculation.

Then, for each table calculation:

  1. Start typing a Centricity expression into the large text box to form your calculation. Centricity expressions can be quite simple, or they can use as many fields, functions, and operators as your business logic requires. The expression you create can evaluate to a number, date, string (text), or Boolean (true/false).

  2. Optionally, click the Format drop-down to choose a predefined format or create a custom format for the results. If you create a custom format, use Excel-style formatting. If no selection is made, Centricity uses a default format.

  3. Rename your table calculation from the default name, if desired.

  4. Add an optional description to provide more information about the table calculation to other users.

  5. If you are finished adding table calculations, click Save to add the calculation to the Explore.

The field picker also displays your new table calculation in the Custom Fields section. As with other fields, you can click a table calculation’s name to add or remove it from an Explore query.

Sorting table calculations

To sort on a table calculation, click the field name at the top of the column, just as you would a dimension or measure.



 

 

More questions about Centricity? Check out our website or talk to our Support Team.