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 spot trends and 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 or value of each measure, which starts at zero. | |
Example |  |  |
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.
Prepare the data in the grid:
In Period mode, select the Product dimension, then select and focus on the top ten products (highest sales).
Select Period > Rolling 12 months.
Click the Summary button to view the total of the selected products across the period.
Click the Chart button in the top right toolbar above the grid.
Click the Line chart category button on the left of the chart and select the Line option.
The lines in the chart depict the current and previous values. You can see that the selected products are selling better in almost every month this year (blue) compared to last year (red).
(Optional) Select the Use cumulative option to chart current vs. previous cumulative for each time unit, rather than simply current vs. previous.
(Optional) Save the chart as a favorite or add it to a dashboard.