Creating Visuals with Optional Measures

  1. Open the visual Regional Populations in Edit mode.
  2. Ensure that you are using the table chart visual type.
  3. From Measures, select and move life_expectancy field onto the Measures shelf.
  4. On the Measures shelf, select life_expectancy field, select the Aggregates menu, and then select Remove Aggregate.

  5. Click Refresh Visual.

    Note that a new column, avg(life_expectancy), appears in the table.

    Set-up for Visual
    Set-up for Visual
  6. On the Measures shelf, select life_expectancy field, and then select Enter/Edit Expression menu.

  7. In the Enter/Edit Expression modal window,

    • Change the text to the following expression: [<<mes:>>].
    • Click Validate Expression.
    • After successful validation, click Save.
    Creating an Optional Measure in Enter/Edit Expression Interface
    Creating an Optional Measure in Enter/Edit Expression Interface

  8. Click Refresh Visual.

    Note that the column life_expectancy is no longer in the table.

  9. Click Save to save the changes to Regional Populations.