MultiDrill Chart

This is the N4V FOR WEBI Wiki page for the MultiDrill Chart widget.

Updated for N4V 2025.2.10

• Visualization of 1 to 5 measures that can be rendered as Lines, Areas, Columns, Bars, depending on the type of chart chosen.
• Select 1 to 5 dimensions and up to 5 measures.
• Each dimension is drillable to descend into the lower category (up to 4 sub-levels can be defined).
• A pre-calculated measure in Webi (rate, distinct count, etc.) can be passed as input. When used, the measure is provided in the form of as many indicators as there are drill levels (dimensions). For example, to display a distinct count on 3 drill levels, the “count” measure will be calculated in Webi in 3 indicator type variables (count for level 1, count for level 2, count for level 3) and these 3 indicators will be passed to the MultiDrill element in the area provided for this purpose. The N4V engine will then not perform any aggregation on these measures; they will be displayed as is.
• Ability to use the linked elements functionality on this chart.

• Dimension 1 : Dimension 1
• Dimension 2 to 5 : [Optional] Drilling dimensions

• Measure 1 : Measure 1
• Measure 2 : [Optional] measure 2
• …
• Measure 5 : [Optional] measure 5

• Precalculated measure 1 to 5 : [Optional] Measure drill level 1 to 5

• Show the tooltip(s) when you move the mouse over the points of the graph.
• Click on a level 1 column to go down to level 2 for the chosen dimension 1 value.
• Same from level 2 to level 5.

Use the native Webi element link function to make this chart interact with other elements of the same report (Webi native tables/charts and/or Need4Viz charts). The element link can be defined on all objects or individually on one of the dimensions of the chart.

You can find instructions for accessing settings for Need4Viz graphics: Format Custom Element.

For the MultiChart, the available parameters are:

Global

• Palette and Style
  • General : You can use the palette tool to define the colors used to build the graph.

Extended parameters

• Global → See the user guide for the “Global” section here

• Menu → See the user guide for the “Menu” section here

• X_Axis & Y_Axis → See the user guide for the “Axes” section here
  • Common Y-axes settings : You can choose here to align all the Y axis on their threshold value (0 by default)

• Options
  • Zooming : Select here the kind of zooming to activate on the chart
  • Chart type : These settings allows you to choose the default type of the chart displayed (lines, columns, areas…). You can choose a different kind of chart on each drill level or for each individual measure.
  • Colors : This setting allows you to choose kind of colors for the chart.
  • Lines : Common settings for lines and areas. Choose here the style end width of lines.
  • Columns & Bars : Common settings for columns and bars. Choose here the corner radius (all corners or only top corners) of columns/bars borders and the width of bars.
  • Shadow : This setting allows you to draw a colored shadow around the columns.
  • Markers : This setting allows you to display or hide the markers

• Selection → See the user guide for the “Selection” section here

• Controls → See the user guide for the “Selection” section here

• Tooltip → See the user guide for the “Tooltip” section here

• Legend → See the user guide for the “Legend” section here

• Labels
  • Values labels : Choose here the rotation of labels and set the same style for hyperlinks labels

• Options-measure 1,2,… 5
  • Values : This setting allows you to specify the name of the measure in the labels (replaces the Webi object name, %SECTION% N4V variable can be used in the label), the unit to add as a measurement prefix or suffix as well as the measurement accuracy. The measurement display format (standard - e.g.: 2,345.67, compact - e.g.: 2.3K or compact long - e.g.: 2.3 thousand) can also be defined.
  • Chart: Here you can deactivate the chart when opening (click on the corresponding item in the legend to reactivate it).
  • Display labels : You can choose here to display/hide the labels of the measure or to place them inside the bars/columns.
  • Threshold : This setting allows you to fix the threshold for “negative values” (default is 0) and the colors for negative and positive values.
  • Outline & Markers : These settings allow you to change the style of lines & outlines and to show or hide or change the markers on the lines. You can also change the size of the lollipop bubbles here. You can define here the shape of markers for the measure. A list of predefined shapes is available but you can also define your own shape based on a PNG image link. The value can be set inside or outside the marker.

• Options-measure 2,3,… 5
  • Y Axis : Choose here to use the main Y-Axis for the measure or another Y-Axis
  • New Y-Axis properties : Set here the new Y-Axis defined for the measure

Export Server → See the user guide for the “Export Server” section here

Export FTP → See the user guide for the “Export FTP” section here

Export SharePoint → See the user guide for the “Export SharePoint” section here