Dynamic Selection Of Datasets

 

 

The Dynamic Selection of datasets gives users more control over selecting data sources for their queries and visualizations.

Instead of making manual selections to datasets or applying separate filters to a specific country, dataset year, time period, etc., then changing the selections and filters to load results by different datasets, Dynamic selection can be used instead to make this more efficient.

 

Dynamic Selection starts off in the Get Data section of Analyze and is available with any study that is configured for this option.

The majority of studies will be compatible with Dynamic selection.

 

To confirm whether a study is compatible with Dynamic selection, the Selection Mode menu will include options for Manual and Dynamic.

Also, additional Filter options will be displayed beneath the Selection Mode menu.

If there is no Dynamic menu option and the Filter menu options beneath the Selection Mode menu are not present, then the study is not compatible with Dynamic selection.

 

 

The Selection Mode option will be set to Manual by default.

Instead of proceeding with the Manual setting, select the Dynamic option instead.

 

 

 

 

After changing the Selection Mode from Manual to Dynamic, the filter selectors that were previously displayed in a row-orientation beneath the Selection Mode menu are now listed vertically as selection rules.

 

Note: When using the Dynamic Selection mode, the list of datasets displayed on the right is read-only.

Dragging datasets in or out of the list is not allowed with Dynamic Selection.

Switch the Selection Mode back to Manual to drag datasets in or out of the list.

 

Begin defining selection rules by clicking the edit (pencil) icon on the right-side of the dataset selection rules.

 

 

 

Select one of the four settings:

(makes all datasets available in the Analyze query)

(user picks which datasets will be available for use in the query)

(a selectable link to the datasets by creating a parameter menu option)

(for selection rules related to time periods; user specifies a certain number of datasets to include based on how old or recent)

 

In this example, Pick Manually is chosen.

Based on the selection, only EU5 datasets will be loaded in the list of available datasets.

 

 

 

This next example focuses on the Bind the Attribute to a Parameter option.

 

If no parameters exist yet or to create a new parameter, click the Create New button and a parameter will automatically be created and assigned a name.

 

 

 

 

A new parameter named Country is created and will be selectable under the Parameters menu in Analyze and Compose.

 

 

 

 

If parameters were already created, to load an existing one, click the drop-down arrow to select an existing parameter menu from the menu options.

 

Similar to the example above for creating new parameters, any existing parameters are selectable under the Parameters menu in Analyze and Compose.

 

Continue defining the selection rules by clicking the edit (pencil) icon of the next selection rule (Year).

 

 

 

Since the Year example consists of years (time periods), the First / Last option can be applied.

 

 

 

 

Depending on how the years are arranged in the question, select either the option for First or Last.

 

If only the most recent 3 years of data need to be included in the query, the First / Last option can be used with a criteria of “3”.

The definition of the parameter will be modified to include the last 3 years of data.

 

 

As more selection rules are applied, the list of datasets on the right will be reduced.

Note: Since the rule for year only includes the “last 3”, the datasets listed only include 2016, 2017, and 2018.

 

Continue to define the remaining selection rules if desired.

Not all selection rules need to be defined.

The default setting can remain at ‘Any’ for the rules.

 

 

 

Proceed to Analyze and build a query or visualization.

 

 

 

 

Data Sources in the upper-left show only datasets for 2016, 2017, and 2018.

This reflects the “Last 3” selection rule that was assigned in the previous step.

 

Under Parameters, the “Country” selector can be changed to any of the other country options.

The “Last 3” rule will automatically be applied.

 

Dynamic selection allows users to make dataset selections easier and more efficient versus manually changing and loading datasets.