Adding a new calculated measure

Last Updated : Jan 31, 2024 |

About this task

When you create a view, you can use a calculated measure. A calculated measure can be a standard measure or a conditional measure. You cannot select time variables when creating calculated measures.

Procedure

  1. Log in to Realtime Reporting.
  2. Click the Dashboard Preferences icon.
  3. Click Calculated Measure Manager.
  4. On the Calculated Measure Manager page, click the Add New icon.
  5. In the Name field, type the name of the calculated measure.
  6. In the Description field, type a description of the new calculated measure.
  7. Select any of the following:

    • Standard: Use mathematical functions to create a standard measure.

    • Conditional: Use logical operators to create a conditional measure.

  8. In the Producer list, select a producer that Analytics for Avaya Experience Platform™ Public Cloud provides.
  9. To format the decimal placement in standard measure, select one of the following:

    • Round to nearest whole number

    • Round to 2 decimal places

  10. To format the percentage for a standard measure, select one of the following:

    • Round to nearest whole number

    • Round to 2 decimal places

    For example: To add a calculated measure of the percentage value of offered interactions, which the agents did not answer, do the following:

    • From the Producer list, select the required producer.

    • In the Calculated Measures pane, enter the following calculation: Not Answered / Offered * 100

  11. To display the information in the summary row, you can select any of the following:

    • Sum all values in the measure column

    • Calculate value based on summary row output from chosen measures

    You can also choose not to display a summary row value.

  12. To calculate a standard measure, in the Standard Measure pane, do the following:
    1. In the Add Measure list, select the measures.
    2. Select the calculation symbols to add to the preview.

      The supported calculation symbols are (, ), +, -, /, *, and -.

    3. In the Add Number list, select the required number.
  13. To calculate a conditional measure, you can select a combination of IF or ELSE statements to create the desired calculated measure.

    • You can create a maximum of four logical operations using AND and OR operators.

    • A conditional measure can have only a maximum of four ELSE IF statements.

    • In the Value field of IF and ELSE IF statements, special characters are not allowed. However, period and underscore are allowed.

    • The ELSE statement is always default.

  14. Optional If you are logged in as a reporting administrator, enable the Shared switch to share the calculated measure details.
  15. Click Save.
Related information
Creating a New Calculated Measure
Creating a New Conditional Measure