Bookmark and Share Share   

Sparkline Win-Loss

A Sparkline Win-Loss chart displays the variations with respect to an origin line of one or more data points (series or columns) over time or categories. Each series is displayed as a set of bars in relation to one origin line, with a bar for each record progressing in the order that records appear in the dataset. One typical use is to display data points as win/loss/draw or profit/loss/break-even.

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 to bars.

For more information on using the Sparkline Win-Loss view, see Characteristics and Configure This View. For alternate formats, see Sparkline Column and Sparkline Column.



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 with origin line for bars in the chart. In the example shown above, there are five series for Income Tax, Property Tax, Sales Tax, Business Taxes and Other Taxes.

Published Events

None

Mobile Views

No

Configure This View

Choose the SparkLine Win-Loss 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 with origin line 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 a Caption, and optionally a Subcaption for the X/Y axis. Captions appear as a label to the left of the origin line.

  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.