Arcadia Enterprise has a built-in approach to adjusting the level of granularity of an application at run-time. To do that,
Variable measures can be implemented independently of variable dimensions. However, this demonstration builds on the work completed in Receiving Variable Dimension Parameters in Dashboards to emphasize just how much control can be built into Arcadia Enterprise applications.
This demonstration uses the US County Population dataset.
You may choose to duplicate the dashboard that you created earlier according to the instructions in Receiving Variable Dimension Parameters in Dashboards. In this case, open the visual, and skip to Step 7 in this workflow.
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 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,
<<agg:sum([Tot
Pop])>>
.<<dim>>
and <<agg>>
.Before starting on this work flow, complete the steps in Creating Visuals with Variable Measures.
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 agg.
Note that this is the parameter from Creating Visuals with Variable Measures.
Under Specified values, enter the following two rows:
sum(tot_pop)
, Label:
Total Populationsum(tot_male)
, Label:
Total Male Populationsum(tot_female)
, Label:
Total Female PopulationNote that these are the original field names in the source table.
Switch to Display Settings tab, and select the options Permit only one item to be selected.
Click Apply.
In the Population Type filter, select Total Female Population.
Note that the title of the graph and the vertical axis changed to include sum(tot_female).
To check the parameters of the dashboard, hover the pointer over the (filter) icon at the top right corner. They are
dim: Stname, dim.alias: State
and agg: sum(tot_female),
agg.alias: Total Female Population
.
Notice that you can operate the two filters, Dimension Level and Population Type, independently.
You can also navigate between the permutations of filter outputs you create by using filter navigation controls at the top right corner.