416.467.9100 | Dundas Data Visualization | Login
Welcome Guest
This is the support page for the legacy Dundas Dashboard application. For assistance with the current Dundas BI application please click here.
Dashboard v5.0

This site makes extensive use of JavaScript.

Please enable JavaScript in your web browser and reload the page before proceeding.

Small Multiples Examples

Hide navigation
RSS
Modified on Fri, 31 Aug 2012 06:20 PM Categorized as Data Controls, Small Multiples
Click to return to: Documentation | Designing Dashboards | DV Controls | Small Multiples


Overview

The examples below show how to accomplish various tasks using the Dundas Dashboard Small Multiples control, or use some of its more advanced features.

Examples

KPI with a splitter

The following example shows how to use the small multiples control to display a KPI with a splitter dimension:

  1. Prepare a virtual table as shown in this figure.
    Virtual table with splitter data.
  2. Set up a Sales KPI based on the virtual table and use the following settings:
    • Measure - Sales
    • Instant dimension - Country (axis dimension and splitter dimension)
    • Instant dimension - City (axis dimension)
    • Filters - None
    • Preferred visualization - Display Indicator
  3. Create a new dashboard:
    • Add the Small Multiples control to the dashboard.
    • Add the Sales KPI to the small multiples control.
  4. In the Small Multiples Data Binding wizard:
    • Set the Row Dimension to Country, which is the splitter dimension from the KPI. The Use Splitter Axis checkbox will become enabled.
    • Select the Use Splitter Axis checkbox. The Column Dimension will become disabled.
    • Set the Color Dimension to City. This will assign a background color to each cell based on the City dimension value.
    • Bind the DisplayIndicatorChild control by selecting its checkbox. Choose Sales as its metric field.
      Binding the KPI splitter.
  5. Set some appearance properties of the small multiples control:
    • Column Header Visibility - Collapsed
    • Row Header Width - 100.
  6. Save, and then preview the dashboard.
    Splitter preview 1.

When the Use Splitter Axis option is enabled, the small multiples control splits the data into rows based on the splitter dimension from the KPI. For every unique splitter dimension member value (⪚ Country), a corresponding row is created. The Column dimension dropdown is disabled in the data binding wizard because the columns are automatically generated based on the number of cities per country. The column headings are just indexes in this case so that is why they are hidden.

But one problem with the above dashboard is that you can't tell which city corresponds to which cell (display indicator). Follow the steps below to add a Data Label control which will display the city name within each cell:

  1. Add a Data Label control to the small multiples control.
  2. Use the small multiple control's Data Information menu to access the Small Multiples Data Binding wizard. Bind the DataLabelChild control to the KPI.
  3. Open the Cell Children collection editor.
  4. Set properties of the DisplayIndicatorChild:
    • Height - 50
  5. Set properties of the DataLabelChild:
    • Top - 60
    • Data Column - [Sales].[City]
  6. Save, and then preview the dashboard.

The completed dashboard.

The completed dashboard.


Related topics


Click to return to: Documentation | Designing Dashboards | DV Controls | Small Multiples

About Dundas | Contact Us Follow us on Twitter! | Privacy Statement | Report Site Issues

Copyright © 2009-2014 Dundas Data Visualization, Inc.