Generate filtered versions of the same chart with "multiples"

Updated at July 13th, 2021

With Protobi's new "multiples" feature, you can generate versions of the same chart that are filtered to different subsets. 

In the example below, there are two versions of chart Q19. One that is filtered to show only data from the North East, and another for the Mid West. 


How to create multiples

Identify the variable

To create multiple versions of a chart (e.g. Q19), identify the element that will be used to filter each chart to the appropriate subset. You can use banner variables like "Country", or any variable with a set of discreet values.

For instance, to create charts filtered on specific regions, the example above uses S4 (Which region do you practice in?). 

Original chart:

Element to be used as multiples:


Edit the multiples attribute

Open "Edit properties" and add the element key next to the multiples attribute. 


Result

The result is seven versions of Q19, each filtered on a different value of S4. Notice that every chart will inherit the title and value formats of Q19


The displayKey, x axis title and footnote indicates which filter is applied to the chart.


Multiples are based on formatted values

Every value of S4 has a format specified, so when used as a multiple S4 will generate 7 different filtered versions of any given chart.

Remove the format for value 1 (i.e. "North East"), and Q19 would no longer show the version of the chart that is filtered on "S4" : 1. However, the other values that have formats will get one chart each.

Multiples will respect hide and sort order

Charts are not generated for hidden values, and if an alternative sort order is specified the charts will respect that order. 

Formats for raw values can be specified in the format dialog.



Was this article helpful?