Creating visuals with variable measures
- In the dashboard, click New Visual.
- Under the Data menu, select the US County Population dataset.
- Under the Visuals menu choose the Bar Chart visual type.
-
Populate the shelves of the visual:
- From Dimension, select and move
Stname
field onto the X Axis shelf. - From Measures, select and move
Tot Pop
field onto the Y Axis shelf. On the Y Axis shelf, change the aggregation of the Tot Pop field from
sum(Tot Pop)
toavg(Tot Pop)
: selectTot Pop
field, chose the Aggregates menu, and change the aggregate from Sum to Average.- On the Y Axis shelf, click
Tot Pop
, and under the Field Properties menu select Order, and choose Ascending.
- From Dimension, select and move
-
Click Refresh Visual to see the basic set up of the bar chart.
-
On the Y Axis shelf, click the
sum(Tot Pop)
field. -
In the Field Properties menu, select [ ] Enter/Edit
Expression.
- In the Enter/Edit Expression modal window,
-
Change the text to the following expression:
<<agg:sum([Tot Pop])>>
. - Click Validate & Save.
-
Change the name of the visual to Population by <<dim>> and
<<agg>>. To have an informative title for the visual, you may add the
parameter placeholders to it. The filters configured in Creating filters to control variable dimensions and Creating filters to control variable measures supply the
required values for
<<dim>>
and<<agg>>
. - Click Save.