Sign in
x
☰

Create multiple versions of your chart filtered on banner values

An alternative to crosstabs

Updated at 2021-04-20

The "multiples" feature generates different versions of the same chart using the banner element as filters. 

For example we can use Region as a multiples banner on Q19. The result is one chart for every region subset. 

Three side-by-side 100% stacked bar charts displaying Q19 responses filtered by Region, showing prescription packet distribution with North East at 57% one month, Mid West at 46% one month, and Mid Atlantic showing 52% three months.

How to create multiples

Drag + shift + drop

Drag the banner to the chart you want to multiply and press shift before you drop the banner on the pill. 

Protobi interface demonstrating drag and drop functionality with a tooltip reading 'Drag + shift + drop' as the Region banner element is being repositioned to Q19, with sidebar showing Region responses (North East 21.2%, Mid West 26.7%, Mid Atlantic 30.9%) and specialty questions S1 and S2 below.

Edit the multiples property

Alternatively, you can also add the banner key next to the multiples attribute "Edit properties". 

Element properties dialog box for Q19 displaying configuration fields with 'When adding the monthly packets' as headline text, type set to '(default)', field as 'data field', showMissing and showPercent both on '(default)', and valueFormat specified as '0.1f' for one decimal place formatting.

Result

The result is seven versions of Q19, each filtered on a different Region. 

Full Protobi interface displaying Q19 question filtered by Region, showing six regional charts (North East N=234, Mid West N=294.7, Mid Atlantic N=341.2, South East N=138.3, North West N=71.9, South West N=8.9) with varying distributions of prescription packet preferences. Left sidebar shows banner selections including Region, S1 specialty, and S2 grade questions.

The banner labels show as headers in the multiples:

Detailed view of Q19 with Region filter showing two charts: North East displays 57% one month (light blue), 15% two months (green), 22% three months (dark blue), and 5% other (yellow) with N=234; Mid West shows 46% one month, 37% two months, 17% three months with N=294.7.

Press on values to drill in

You can press on values within the multiplied charts, but the project will be filtered as though you're drilled into the value at the overall level. 

For instance if you press on the 57% (1 - one month) you will be drilled into all respondents that selected 1 - one month, not just North East respondents that selected that option. 

Q19 filtered by Region showing two simplified charts where North East and Mid West both display 100.0% for the '1 - one month' category in solid light blue bars, indicating a filter has been applied to show only respondents who selected the one month option.

Result after pressing on 1 - one month:

'Edit format: Region' dialog displaying seven region values (North East, Mid West, Mid Atlantic, South East, North West, South West, West Coast) with columns for Value, Format, Mean, Sort as, Sort last, Hide, and Remove. The Hide column shows checked checkboxes for North East (value 7) and Mid West (value 6), indicating these two regions are set to be hidden from display.

Multiples are based on formatted values

Every value of Region has a format specified, so when used as a multiple Region 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. However, the other values that have formats will get one chart each.

'Edit format: Region' dialog with Logic tab active, displaying seven NHS regions with their assigned Mean values (North East=7, Mid West=6, Mid Atlantic=5, South East=4, North West=3, South West=2, West Coast=1). North East and Mid West have blue checkmarks in the Hide column indicating they will be hidden from the visualization.

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. 

'Edit format: Region' dialog displaying seven NHS regions with Mean values assigned, where North East (Mean=7) and Mid West (Mean=6) have blue checkmarks in the 'Sort last' column, indicating these two regions will appear at the end of the regional ordering in visualizations.

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