Bookmark and Share Share   

Sparkline Column

Sparkline column charts are useful in displaying the fluctuation of a one or more data points (series or columns) over time or categories. Each series is displayed within an X/Y axis with vertical columns for each record progressing in the order that records appear in the dataset. Like other sparkline charts, Sparkline Columns illustrate the change between records for a given data point and the difference in fluctuations between data points.

The number of records determines how many bars appear on each line. For large numbers of records (> 50), you can use pagination with this chart to provide better visibility for bars.

For more information on using the Sparkline Column view, see Characteristics and Configure This View.

For alternate formats, see Sparkline and Sparkline Win-Loss. For a reverse relationship between records and data points, see the Column Chart or Bar Chart.



Characteristics

Requirements

A set of repeating items with at least one field with numeric data. Each field with numeric data that you add as a series defines an X/Y axis for bars in the chart. In the example shown above, there are three series for High, Low and Volume.

Published Events

None

Mobile Views

No

Configure This View

Choose the SparkLine Columns view and:

  1. If needed, change the Select Repeating Element field to find the repeating items that contain the fields you want to chart. This must be the parent node to the fields you want to use and it must be a repeating node.

  2. Drag at least one column that contains numeric data into the Series field. Each column you add to Series adds an X/Y axis to the chart.

    You can click Show Data to see the actual data and simply drag the appropriate column title. Hide Data closes this and shows just the column names.

    For best results, limit the number of series to 8 or less.

    It is also best if the numeric data are distinctly different but within a similar range of values. One very large or very small value can skew the chart scale, making it difficult to see or understand other data.

  3. For each series, set these properties:

    • Set a Caption, and optionally a Subcaption for the X/Y axis. Captions appear as a label to the left of the X/Y axis.

    • If needed, add a prefix or suffice for the numeric labels for this line.

      Common examples might be $ as the prefix or % as the suffix.

  4. Click Next and optionally set a Caption for the chart.

  5. If needed, click Switch to advanced mode to set other visual properties for the chart. See Advanced Configuration Properties for details.

  6. Preview the chart at any time.

  7. Once you are satisfied, save the view:

    1. Click Finish.

    2. Give the view a name, and optional description.

    3. Click Save.