Arcadia Enterprise has a built-in approach to adjusting the level of granularity of an application at run-time. To do that,
This demonstration uses the US County Population dataset.
Populate the shelves of the visual:
Stname
field
onto the X Axis shelf.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)
to avg(Tot Pop)
: select Tot
Pop
field, chose the Aggregates menu, and change the
aggregate from Sum to Average.
Tot Pop
, and under
the Field Properties menu select Order,
and choose Ascending.Click Refresh Visual to see the basic set up of the bar chart.
On the X Axis shelf, click Stname
field.
In the Field Properties menu, select [ ] Enter/Edit Expression.
In the Enter/Edit Expression modal window,
<<dim:[Stname]>>]
.Change the name of the visual to Population by <<dim>>.
To have an informative title for the visual, you may add the parameter placeholders to it. The filter configured in Creating Filters that Control Variable Dimensions supplies the required value.
Before starting on this work flow, complete the steps in Creating Visuals with Variable 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, switch to Values tab, and enter the following:
Under Output Parameter, enter dim.
Note that this is the parameter from Creating Visuals with Variable Dimensions.
Under Specified values, enter the following two rows:
stname
,
Label: Statectyname
,
Label: CountySwitch to Display Settings tab, and select the options Permit only one item to be selected.
Click Apply.
Switch to application View mode.
Note that the default choice, Stname, displays both on the horizontal axis, and in the title of the visual.
To check the parameters of the dashboard, hover the pointer over the (filter) icon at the top right corner. They are
dim: Stname
and dim.alias: State
.
In the Dimension Level filter, select County.
Note that now the title of the graph and the axis changed to use Ctyname.
You may also notice that your graph does not appear to have any bars. In this particular dataset, there are large differences among populations of various counties; a great majority has populations under one million, and a select few represent urban areas with extremely dense population.
In the application, scroll to the extreme right of the visual to see the graph.
If you want to check the status of parameters on this dashboard, hover the pointer over
the (filter) icon at the top right
corner, and notice that they changes to dim: Ctyname
and
dim.alias: County
.