- Open the visual Regional Populations in edit mode.
- Ensure that you are using the table chart visual type.
- From Measures, select and move
life_expectancy
field onto the Measures shelf.
- On the Measures shelf, select
life_expectancy
field, select the Aggregates menu, and then select Remove Aggregate.
Click Refresh Visual.
Note that a new column, avg(life_expectancy), appears in the table.
- On the Measures shelf, select
life_expectancy
field, and then select Enter/Edit Expression menu.
In the Enter/Edit Expression modal window,
- Change the text to the following expression:
[<<mes:>>]
.
- Click Validate Expression.
- After successful validation, click Save.
Click Refresh Visual.
Note that the column life_expectancy is no longer in the table.
- Click Save to save the changes to Regional Populations.