Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

A line chart plots performance over time, e.g., a customer's sales for this year vs. last year. When you select a dimension you see a line for each focused item in the dimension. In summary view there will be a line each for current and previous period or stream

 

Table of Contents
maxLevel2
minLevel2
indent15px
 

Example - compare sales year on year

Create a line chart showing
Info

Availability:

  • Summary view-All modes except for Transaction mode.

  • Focused view (when you select and focus on items in a dimension) - Period and Moving mode only.

A Line chart plots performance over time and allows you to make comparisons, for example, a customer's sales for this year vs. last year.

 

Summary view

Focused view

Contents

There is a blue line for the current period (or stream) and a red line for the previous period (or other stream).

There is a line for each of the focused items.

X-axis

The X-axis displays the time units of your current period. 

Y-axis

The Y-axis displays the total, which starts at zero.

Example

Image AddedImage Added

Example - Create a Line chart

In the Sales database, create a Line chart to compare the sales of a particular product this year compared to last year. This example uses a 'Sales' database. Step 1:

  1. Prepare the data in the grid

as follows
  1. :

Select
    1. In Period mode, select the

'
    1. Product

' dimension Then choose a product and FocusSelect
    1. dimension, then select and focus on the top ten products (highest sales).

    2. Select

Summary.
    1. Period > Rolling 12 months.

Info
iconfalse
titleRelated articles

Step 2: Choose Chart and select Line Image Removed .

  • The y axis will display the total.
  • The x axis will display the time units of your current period (e.g. months/days/years)
      1. Click the Summary button.

    1. Click the Chart (blue star) button, then click the Line chart category button on the left of the chart and select the Line option.

      Image Added

      The chart shows that the selected

    product
    1. products are is selling better in almost every month this year (blue) compared to last year (red). 

    The chart can now be saved as a favorite or added to the dashboard (see Add a widget from the grid). 

    Image Removed

    Compare cumulative data in a line chart

    You can select
    1. Image Added

    2. (Optional) Select the Use cumulative option

    at the left of a chart to chart current cumulative
    1. to chart current vs. previous cumulative for each time unit, rather than

    simply current
    1. simply current vs. previous.

     Image Removed

    Image Removed

    1. Image Added
    2. (Optional) Save the chart as a favorite or add it to a dashboard.