Friday, December 2, 2022
HomeBig DataCreate small multiples in Amazon QuickSight

Create small multiples in Amazon QuickSight

We’re excited to announce the launch of small multiples in Amazon QuickSight at AWS re:Invent 2022! Small multiples is without doubt one of the strongest knowledge visualization options in relation to comparative evaluation. Beforehand, you needed to both use a filter or create a number of visuals aspect by aspect to investigate multiples slices of the identical knowledge. With the launch of small multiples, authors can merely add a dimension to the Small multiples area nicely to create a number of variations of the identical chart.

On this publish, we discover this new function and its advantages.

What are Small Multiples?

Small multiples (aka trellis, side, lattice, grid, or panel charts) permits you to evaluate knowledge throughout many values for a given dimension. It splits a base visible into a number of variations of itself, offered aspect by aspect, with its knowledge partitioned throughout these variations by a dimension. It supplies a better technique to get a holistic view of your small business as a substitute of knowledge in silos. For instance, you possibly can view how your small business is doing in every state without having to create over 50 totally different visuals. As a substitute, you possibly can see one visible with a number of small charts within it, as proven within the following screenshot.

Frequent use instances for small multiples

The small multiples function supplies the next advantages to your use instances:

  • Comparative evaluation with simple sample recognition – You need to use small multiples to match totally different subsets (classes) of the identical dataset. In comparison with animation, small multiples presents the entire knowledge without delay, making it simpler for viewers to naturally evaluate every chart with others, as a substitute of attempting to flip forwards and backwards between views.
  • Clear and digestible knowledge – Making an attempt to show a number of variables in a single chart can result in overplotting and obscure readers, which might be overcome utilizing small multiples(refer beneath instance). Additionally, as soon as the reader understands the design of 1 chart, they’ll apply this information as they scan the remainder of the charts. This shifts the reader’s effort from understanding how the chart works to what the info says, which makes decoding the chart lot simpler.
  • Storytelling – Small multiples is a superb device usually utilized by newspapers to depict a narrative and permit prospects to view modifications in patterns (for instance, think about the next Washington Submit article).
  • Observe or view a number of slices of knowledge without delay – You possibly can monitor a number of sources without delay with out producing a number of visualizations or filtering to slice and cube the info.

Create your individual small multiples in QuickSight

Presently, you possibly can create small multiples on vertical bar, clustered bar, line, twin axis line, and pie charts. To get began, create one of many supported visuals and drag the sector by which you wish to partition the info to the Small multiples area nicely. This creates multiples of the chart break up by the dimension assigned in a grid style.

For charts supporting axes like line and bar, the X-axis is made widespread throughout charts. This supplies a cleaner look to simply spot developments and establish the ache factors or contributing elements. The axis show settings and axis titles are managed by the person chart settings. The next screenshot exhibits an instance.

Styling small multiples

You possibly can customise the model of small multiples within the following methods:

  • Select a structure – For ease of use, small multiples by default chooses the very best panel structure relying on the cardinality of the sector. You may also regulate the variety of rows and columns as much as a max of 10 rows per column and 64 panels. Any multiples that don’t match within the structure are loaded as you scroll vertically. Within the following instance, we have now chosen two rows and three columns as our structure. This implies you solely see six panels at a time; the remainder might be accessed through vertical scroll.
  • Restrict panels – You possibly can outline the utmost variety of panels to be displayed primarily based on the kind order utilized on the sector in your Small multiples area nicely.
  • Format panel titles – Panel titles add context to the multiples being seen. You possibly can add wealthy textual content formatting like font styling and alignment choices.
  • Customise panel styling – You possibly can additional customise the small multiples feel and appear by taking part in round with the panel border styling choices, adjusting the panel spacing, and including panel background colour.

Interacting with the info

  • Sorting– Relying on the chart sort, you possibly can type by axis, worth, and small multiples fields in ascending or descending order.
  • Filtering experience- You may also set filter actions in identical approach you set for different charts. Filtering on small multiples will move each the small multiples and axis (in case of line or bar charts) or group (pie charts) context.

Extra to come back

We’re enthusiastic about our launch, and we have now tons extra deliberate for small multiples. In upcoming releases, we are going to sort out the present limitations:

  • Drill-down is at present not supported for small multiples.
  • Reference traces have been disabled for now.
  • Present Different small multiples panel will not be supported.
  • Small multiples isn’t supported when the first class is sorted by a area that has the distinct rely aggregation perform.
  • Small multiples doesn’t assist calculated values with desk calculation.
  • Knowledge zoom on the X axis for line and bar charts is disabled for now.
  • Panel title will not be displayed within the tooltip by default. To see it, you need to manually customise the tooltip and add a Small multiples area in it.


On this publish, we regarded on the small multiples options, and discovered about its varied use instances and the way to configure them in QuickSight. You possibly can analyze knowledge by a number of dimension attributes in an easy-to-understand and easy-to-maintain approach. With small multiples, readers can rapidly see which classes are most vital, and spot developments and insights. Begin utilizing small multiples to counterpoint your dashboards’ present visualization and unlock new enterprise use instances immediately!

Concerning the Creator

Bhupinder Chadha is a senior product supervisor for Amazon QuickSight targeted on visualization and entrance finish experiences. He’s obsessed with BI, knowledge visualization and low-code/no-code experiences. Previous to QuickSight he was the lead product supervisor for Inforiver, liable for constructing a enterprise BI product from floor up. Bhupinder began his profession in presales, adopted by a small gig in consulting after which PM for xViz, an add on visualization product.



Please enter your comment!
Please enter your name here

Most Popular

Recent Comments