Calculated Measures

In Bizview, dashboard designers can create their own calculated fields. A calculated field is a field for querying or outputting information that cannot be directly queried or output from a database table. The field's data only appears for the duration of the query and it is not actually stored in the database table.

Calculated fields are created on top of the summarized data returned by the data view.

1. Go to Edit Dashboard and Insert or edit an existing dasharea.

2. Select Create in Data Bindings - Dataview Fields:

A Create Calculated Measure dialog displays. Dataview fields display to the left, with a column for ID, Description, and Data Type.

3. Enter a Field Name and Description.

   Note: The field name must contain at least four letters and can only contain letters a-z (lowercase) , numbers 0-9, and underscores (_).

4. Below the Description, write your desired syntax [aggregation]([cloumn]) [operation] [aggregation]([column])

In this example revenue sum(revenue) / sum(qty)

5. Then, select Create.

   Note: If using CASE-clauses, aggregation must be written in the calculated measure itself and the "AggregationType" should be set to "None". For example, SUM( CASE WHEN [ACCOUNT] BETWEEN 3000 and 3999 THEN [ledger_amount]*-1 ELSE 0 END )

6. The Calculated Measure now displays in the top row of the Dataview Fields, denoted by an fx icon. Drag the measure to the desired container:

If you want to edit or delete your calculated measure you must drag it back to the Dataview Fields list and right-click the measure.