Creating Charts

This topic describes how to add a new Chart Object to a Screen or a Container and its specific properties.

To create a new Chart, you need to access a Screen in Design mode.

Once you're in the Screen editing page, locate the desired Chart from the Screen Objects list in the left panel, then drag and drop it onto your Screen or Container.

When you create a Chart, it is initially empty. The next step is to configure a Layout that will define the data to be displayed in the Chart.

To configure a Layout for a Chart, click the configure icon within the empty Object or select the Chart Object and click the "Configure Layout" icon located in the Properties toolbar to the right side of the Screen.

The Chart, just like every other Object, can be moved, resized, duplicated via copy/paste, and easily aligned with other Objects on the Screen.

See Configure Screen Objects for more details.

Jump to:

• Chart Layout

• Charts properties and settings

• Interacting with charts in Design mode

Chart Layout

The Layout editor for Chart Objects is slightly different from the classic one in that it offers some chart-specific options and properties.
The main differences are highlighted in the image below:

The Axes area

Depending on the chart type, in the Axes area, you can define categories, series, rows, columns, points, and other dimensions.

If you add 2 or more Entities in the "Categories" field, Board will group them according to the following criteria:

• If Entities are related (i.e. they are part of the same hierarchy), the most-nested Entity in a Relationship is always arranged in the rightmost position, and you won't be able to rearrange their order. The least-nested Entity will appear on top of the chart (Entity Grouping), while the most-nested Entity will be shown in the primary X axis

• If Entities are not related, you can freely rearrange their order in the field. To do so, drag and drop them in the desired position. The least-nested Entity will appear on top of the chart (Entity Grouping), while the most-nested Entity will be shown in the primary X axis

The Chart Object doesn't support multiple Entities in the "Series" field. Entity grouping is supported only on Cartesian and Waterfall charts. In all other cases, only the most-nested Entity (i.e. the one in the rightmost position in the "Categories" field) will be shown in the primary X axis. See Charts properties and settings for a full description of options specific to each chart type.

Object properties

In the Layout editor, under the Object settings subpage, the "Block display mode" menu lets you choose between two display modes for Blocks in the Layout:

• All data Blocks tiled. One block viewable at a time: enable this option to view each Block in the Layout
   

• Single data Block. Multiple Blocks stacked, clustered, or as different types: enable this option to view all Blocks at once on a single Chart Object. You can select which Block you want to display from the sliding toolbar in Play mode
   

The "Visible and color blocks" menu lets you show/hide Blocks in the chart and configure a color alert that will be shown in the chart background.

To hide a Block, open the dropdown list and deselect the Block you want to hide.

Blocks hidden using the dedicated option in the Block settings panel won't be available in the dropdown list. The "Block display mode" and "Visible and color blocks" menus are not available for all chart types. See Charts properties and settings for a full description of options specific to each chart type.

To apply a color alert for the chart background, click on the "Color" field and select a Block with a color alert configured in it's Block settings from those suggested.

The color alert will be driven by the values of the selected Block and the chart background color will change accordingly.

Blocks hidden using the dedicated option in the Block settings panel won't be available in the dropdown list.

You can change those settings from the color alert menu in the Block settings panel.

Chart Properties and settings

Chart properties are available from the Object Properties panel on the right side of the Screen editing page once the Chart Object is selected and it's associated with a Layout.

Each chart type has its own specific settings and configuration options. However, all charts share

and the following 2 properties:

• Master Object. If enabled, clicking on a series, a category or a marker (if available) will update the data displayed by all other Objects on the Screen in order to show only the data relating to the clicked item. The Master Object result is similar to applying a Screen Selection
  

• Disable Drill down. Disables the drill down functionality on the selected Chart Object, both in Design and Play mode. (Not available for the Bullet chart)

Read about the chart-specific properties of the following charts:

• Cartesian

• Pie

• Waterfall

• Radar

• Bubble

• Bullet

• Heatmap

• Treemap

Interacting with a Chart in Design mode

In Design mode, the charts provide the same interactive features available in Play mode, with a few notable differences regarding Drill functions.

You can also configure which options will be available in the Object toolbar menu (sliding toolbar) in Play mode. To do so, double click or Ctrl + click the Object and click the Object toolbar icon in the top left corner, then expand it by clicking on the 3 vertical dots: the configuration panel is accessible from the cog icon in the top right corner.

Default Drill down

You can configure a drill-down path that is saved in the chart configuration and performed by default in Play mode when end users click on the Drill down button.

The following paragraphs describe the different types of default Drills you can configure and/or allow the end user to configure: Entities, Screens, Procedures, or Drill throughs.

Drill on an Entity

To configure the default drill on an Entity, proceed as follows:

1. Depending on the chart type, double click on a data point (a bubble, a bar, a rectangle, etc.) or select it and click the Drill anywhere icon

2. From the popup window, select the Entity to drill down on and click APPLY. The configured drill is performed and data is displayed in a Data View

3. Close the Drill down window and save the Screen. The configured drill is now the default drill, both in Design and Play mode

End users will still be able to configure other drill-down paths in Play mode, if they're allowed to do so. See next paragraphs Drill-to-Screen, Drill-Procedure, and Drill throughs for more details.

Screen selections and selections made by the user using Selector Objects (if any) also apply to data in drill down windows.

Limit Drill-down Entities

You can limit drill down paths that end users are allowed to configure by selecting the Entities the user can drill down on from the Drill anywhere configuration window.

To do so, while in Design mode, open the Drill anywhere window and then click on "CONFIGURE" in the top right corner of the window to open the Drill anywhere configuration window.

The "Entities" option is enabled and open by default. From here, you can select/unselect all the Entities that you want to show to end users in Play mode. These Entities will be the only ones available when conducting a drill for both Design and Play mode, however, in Design mode, you can see any hidden Entities from the Drill anywhere window when you enable the "Show hidden" toggle in the top right corner of the window.

All Entities are enabled for Drill down by default.

Drill-to-Screen

To allow users to drill down from one chart to another Screen within the same Capsule using a selection of the chart, proceed as follows:

1. Depending on the chart type, double click on a data point (a bubble, a bar, a rectangle, etc.) or select it and click the Drill anywhere icon 
   

2. From the popup window, click on the "CONFIGURE" button in the top right corner of the window to enter the "Drill anywhere configuration" window
    

3. Click on the "Screen" subpage. Enable the toggle next to the Screen subpage title and select all the Screens you would like to allow the end user to drill to
    

   These Screens will be the only ones available when conducting a Drill-to-Screen from the Object in Design and Play mode, however, in Design mode, you can see any hidden Screens from the Drill anywhere window when you enable the "Show hidden" toggle in the top right corner of the window (which also shows you the hidden drills).

4. Click "APPLY" to close the configuration window

5. From the Drill anywhere window, you can now further configure your Drill-to-Screen with the following options:

   • Select the "Same tab" checkbox to open the destination Screen in the same browser tab
     

   • Select the "New tab" to open in a new tab
     

   • The Drill to Screen mode, if enabled, will open the destination Screen with a selection on the row header (a member of the Entity set By Row) when the user double-clicks on it or selects it and clicks on the Drill-down icon
     

   • The Go to Screen mode, if enabled, will open the destination Screen when the user double-clicks on a row header (a member of the Entity set By Row) or selects it and clicks on the Drill-down icon . The destination Screen won't inherit any selection from the Data View
     

   • The Dynamic Screen option allow to select a Block (an algorithm) to dynamically change the Screen navigation based on another Block values (a text cube containing Screen names)
      

6. Click APPLY to save the configuration

To create a default Drill-to-Screen configuration, do as follows:

1. Depending on the chart type, double click on a data point (a bubble, a bar, a rectangle, etc.) or select it and click the Drill anywhere icon  
   

2. Select the Screen tab. If "Screen" is not yet configured, enable the "Show hidden" toggle in the top right corner of the window
    

   If "Screen" is not yet configured as a drill option for end users from the Drill anywhere configuration window, you will not see a Screen tab in the Drill anywhere window. You can make a default Drill-to-Screen without enabling Drill-to-Screens for the end user. To do so, enable the "Show hidden" toggle in the top right corner of the window to see all the possible drills. If the drill headers are not configured for the end user, they have a "hidden" tag next to their heading.

3. Make a Screen selection and click "APPLY" or double click a Screen to save the Drill-to-Screen default configuration and close the window.

   The Drill-to-Screen configuration process can also be started by double-clicking on a cell or a row header (a member of the Entity set By Row) if a configuration isn't already set.

This feature allows you to nest your analysis in a more powerful way than the standard drill down, which only changes the level of granularity of a report. In a Drill-to-Screen navigation, the data represented (values, indexes) and types of Objects (Charts, Dashboards, Data Views) may vary as the user drills from a top-level view to another Screen at a more detailed level.

Screen selections and selections made by the user using Selector Objects (if any) also apply to data in the target Screen.

Drill-Procedure

It is possible to trigger a Procedure from a chart, when the user double clicks on a data point or selects it and clicks on the Drill down icon. The Procedure is launched with a selection filter applied based on the clicked chart element.

If a Drill-Procedure containing 2 or more Procedures is configured, a popup window allows the user to select the Procedure to run from a configured list when the user double clicks on a chart element.
To allow end users to trigger a Procedure from a chart, you must first enable and configure it from the Drill anywhere configuration window. Once enabled, you can add Procedures you want the user to be able to deploy as well as set a default Drill-Procedure.

To configure a Drill-Procedure, proceed as follows:

1. Depending on the chart type, select a data point (a bubble, a bar, a rectangle, etc.) and click the Drill anywhere icon , or you can double click on a data point if a default Drill has not already been configured
   

2. From the popup window, click on "CONFIGURE" in the top right corner of the window to open the Drill anywhere configuration window and select the Procedures tab
   

3. Select the Procedures for the drill configuration. Choose whether the Procedure comes from the "Capsule" or the "Data model" and then select the Procedure from the dropdown menu (as described below)

   • Capsule. If selected, the dropdown menu to the right allows you to choose from a list of Procedures saved at the Capsule level
      

   • Data model. If selected, select a Data model from the dropdown menu on the right. By doing so, only Procedures belonging to the chosen Data model will display in the dropdown menu to the right
      

4. After you've chosen the desired Procedure, click the ADD button on the right. Repeat the process for each Procedure you want to add to the drill

   To remove a Procedure from the list, select it and then click on "REMOVE" which will appear next to the "ADD" button  

5. Enable Procedures with the corresponding toggle by the tab header to allow end users to configure a Drill-Procedure with the Procedures you just added
    

   If the Procedure toggle is left disabled, its configuration will not be available in Play mode.

6. Click APPLY to save the Drill-Procedure configuration and return to the Drill anywhere window
   

7. Double click a Procedure or select one and click APPLY.

Screen selections and selections made by the user using Selector Objects (if any) also apply to data in Drill down windows.

Drill through

It is possible to execute a Drill through from a chart when the user double clicks on a data point or selects it and clicks on the Drill down icon. The Drill through is executed with a selection filter applied based on the clicked chart element.

Drill throughs are configured in the Drill through section of the Data model.

To configure a Drill through on a chart element, proceed as follows:

1. Depending on the chart type, select a data point (a bubble, a bar, a rectangle, etc.) and click the Drill anywhere icon , or you can double click on a data point if a default Drill has not already been configured
   

2. Click on the Drill through tab and select the Drill through you would like to be the default action when triggered by an end user
    

   If the Drill through feature is enabled from the "Drill anywhere configuration" window, a "Drill through" tab will be visible. If the Drill through feature is enabled and you would like to configure a Drill through on a row header that is not part of the list you configured as available to end users, you can do so by enabling the toggle "Show hidden" and selecting a hidden Drill through.   If the Drill through feature is disabled, you can still apply a default Drill through by enabling the "Show hidden" toggle in the top right corner of the window and selecting a Drill through.

3. Double click the Drill through or select one and click "APPLY" to save the Drill through default configuration.

   You can also double click on the Drill through which will save the configuration and close the window (and you can skip the 4th step).

In order to configure which Drill throughs the end user can use and see in Play mode, proceed as follows:

1. Depending on the chart type, select a data point (a bubble, a bar, a rectangle, etc.) and click the Drill anywhere icon ( ), or you can double click on a data point if a default Drill has not already been configured
   

2. From the popup window, click on the "CONFIGURE" button to open the "Drill anywhere configuration" window
   

3. Select the "Drill through" tab. Enable the toggle next to it and add the desired Drill throughs you'd like to be available to the end user below. If the toggle is not enabled, the Drill through drill down will not be available within the Drill anywhere window (when accessed by the Object toolbar) for designers or end users
    

4. Click "APPLY" to save and return back to the Drill anywhere window where you can now configure a default Drill through
   

5. Click APPLY to save the Drill through configuration.

Screen selections and selections made by the user using Selector Objects (if any) also apply to data in drill down windows.

Learn more about:

• Board Chart properties

• Interacting with charts