Line Chart
Overview
Line charts connect the series of data category data points using a line.
Example
SQL:
SELECT AMOUNT, SOLD_ON as MONTH, ITEM
FROM ITEM_SALES
where YEAR(SOLD_ON) = 2019
Now you will prepare your result set as shown in Data Preparation so that you have the SOLD_ON (MONTH) column sort as a month of the year.
Click the create a chart button to display the Create Chart dialog. Now you will select the appropriate columns to use for the chart. In this example the value will be amount and the category will be month.
After clicking Create Chart, the line chart will be displayed.