Arcadia Enterprise can hide or display measures at run-time. To do that, you must complete the following steps:
You may choose to duplicate the dashboard that you created earlier according to the instructions in Receiving Optional Dimension Parameters in Dashboards. In this case, open the visual, and skip to Step 6 in the following workflow.
Populate the shelves of the visual:
un_region
and un_subregion
fields onto the Dimension shelf.population
field onto the Measures shelf.year
field onto the Filters shelf.year
field, choose Pick values from a list, select 2000
, and click Save.life_expectancy
field onto the Measures shelf.On the Measures shelf, click the life_expectancy
field.
In the Field Properties menu, select [ ] Enter/Edit Expression.
In the Enter/Edit Expression modal window,
[<<mes:>>]
.Before starting on this work flow, complete the steps in Creating Visuals with Optional Measures.
Click Create Custom Filter to create a second dashboard filter.
This creates a New Filter in the filter area of the application, and opens the Settings window modal for that filter.
In the Settings modal window, under the Values tab, enter the following:
Under Output Parameter, enter mes.
Note that this is the parameter from Creating Visuals with Optional Measures.
Under Specified values, enter the following two rows:
life_expectancy
,
Label: Life Expectancygdp_per_capita
,
Label: GDP per CapitaIn the Settings modal window, switch to Display Settings tab, and select Allow only one item to be selected at a time and then select Include an option for 'All'. .
Click Apply.
Switch to application View mode, and select World Regional Populations.
In the Display Measures filter, select Life Expectancy.
Note that the table now has a new column, life_expectancy.
You can change the measure that appears in the visual.
In the Display Measures filter, select GDP per Capita.
Note that the additional column is now titled gdp_per_capita, not life_expectancy.
To check the parameters of the dashboard, hover the pointer over the (filter) icon at the top right corner. They are
dim: country
, dim.alias: Country
, and mes:
gdp_per_capita
. You can scroll down to see the mes.alias: GDP per
Capita
parameter.