Arcadia Enterprise can hide or display dimensions at run-time. To do that, you must complete the following tasks:
This demonstration uses the World Life Expectancy dataset.
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.country
field
onto the Dimension shelf.On the Dimensions shelf, click country
field.
In the Field Properties menu, select [ ] Enter/Edit Expression.
In the Enter/Edit Expression modal window,
[<<dim:>>]
.Before starting on this work flow, complete the steps in Creating Visuals with Optional Dimensions.
Click Create Custom 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 dim.
Note that this is the parameter from Creating Visuals with Optional Dimensions.
Under Specified values, enter Value: country
, and Label: Country.
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 dashboard View mode, and select World Regional Populations.
In the Display Country Details filter, select Country.
Note that the table now has a new column, country.