Sparkline

This is the N4V FOR WEBI Wiki page for the Sparkline widget.

Updated for N4V 2025.3.4

• Visualize the evolution of an indicator as a mini-chart inserted on each value line of a dimension.
  
• Up to 5 measures can be displayed.
  
• There are 7 mini-chart formats: histogram, area, line, curved area, curved line, pyramid, and lollipop.
• The time axis (from 2nd to optional 7th dimensions) can be defined with numeric values for [Year], [Month], [Day], [Hours (24)], [Minutes], [Seconds]
• Possibility to use the functionality of linked elements on this graph (on category and mini-chart).

• Dimension 1 : Dimension for the categories of the chart (lines)
• Dimension 2 : Dimension for Year - the X axis of the mini-chart on each line. (Must be a numeric and non-null value)
• Dimension 3 : [Optional] Dimension for Month - the X axis of the mini-chart on each line. (Must be a numeric and non-null value)
• Dimension 4 : [Optional] Dimension for Day - the X axis of the mini-chart on each line. (Must be a numeric and non-null value)
• Dimension 5 : [Optional] Dimension for Hour (24H) - the X axis of the mini-chart on each line. (Must be a numeric and non-null value)
• Dimension 6 : [Optional] Dimension for Minute - the X axis of the mini-chart on each line. (Must be a numeric and non-null value)
• Dimension 7 : [Optional] Dimension for Second - the X axis of the mini-chart on each line. (Must be a numeric and non-null value)

• Measure 1 : Measure for the first mini-chart
• Measure 2 to 5 : [Optional] Measures for the 2nd..5th mini-charts

• Display the tooltip when you move the mouse over the points of the mini-charts.

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

You can find instructions for accessing settings for N4V FOR WEBI widgets: Format Custom Element.

For the Sparkline, 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

• Options
  • Hover : This setting allows you to choose the color of the hovered line.
  • Grid borders : You can define here the grid format, color and size.

• Charts
  • Mini-Chart options : You can use a gradient color for the mini-charts (partial opacity for areas is not applied when setting a gradient color).
  • Chart Columns options : This setting allows you to specify the corner radius of columns border (all corners or only top corners) and the color/thickness of the borders. You can also set the lollipops radius.
  • Chart lines options : You can define here the line (and area-lines) and markers size. You can also apply a full opacity for areas (partial opacity for areas is not applied when setting a gradient color).

• 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

• Header
  • Header background : This setting allows you to choose the color of the background for the header.
  • Header text : This setting allows you to choose the writing style of the header as well as its left offset and its position.
  • Header padding: This setting allows you to add spacing around the header text (enlarge header cells)
  • Header borders : This setting allows you to define the size and color the upper, lower and vertical borders of the header.

• Categories
  • Header label : You can specify a header label value (by default, it is the name of the categories object).
  • General display : Define here the format to display the categories labels. Category column width can also be fixed.

• Chart-in-tooltip
  • Background : Set here the background color of the charts in the smart tooltips
  • Tooltip title : Add a title/subtitle (and their styles) to the charts in tooltips.
  • X Axis : Set the X axis of the charts in tooltips to be scrollable
  • Y Axis : Add a title to the Y axis of the charts in tooltips

• Measure_1 to 5
  • Values : This setting allows you to define the precision and unit for the first measure. 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.
  • Textual column : This setting allows you to hide or to display the textual values of the measure. Specify the format to this column. Choose the calculation mode to apply (by default, it is the last value of the series that is displayed), possible calculation modes are last value, min/max value, sum or average. You can specify a header value for this column (by default, it is the name of the measure object). The column width can also be fixed.
  • Chart: Common settings for the chart in the column and in the tooltip. Here you can set the color of positive/negative values, the display of value labels and their style, and the display and color of min/max values.
  • Chart in column : This setting allows you to define the type & size of the mini-charts to display. You can specify a header value for this column (by default, it is the name of the measure object). The chart column can also be hidden.
  • Graph in tooltip: Here you can choose to hide the graph displayed in the tooltip (when hovering over the category). You can also choose a different graph representation than the one used in the column.

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