Line charts are a type of data visualization that uses a series of data points called "markers" connected by straight line segments. Line charts are particularly useful for showing trends and changes over a continuous interval or time span.

For this example we will be looking at open incidents over that last 2 years. This data is represented by the line chart below.

Now let's look at the data and chart options.

We are dealing with incidents in this line chart, so we want to use the incident table.

Conditions: We only want to see incidents that are in the State of New, In Progress, or On Hold so the conditions are set to represent that data. The condition builder allows us to query the Incident table based on the specific conditions we set.

Calendar Type: The calendar input can be set to a Standard Calendar or Fiscal Year.

Trend Type: Think of trend type as the makers displayed on the X axis. Trend refers to the general direction or pattern of change in a set of data points over a specific period of time. For this example we are you using the month Trend type so the markers on the line chart X axis will represent a month. Trend types can be set to date, day of the week, month, quarter, week, and year.

Date Range: This input determines the range of time displayed on the line chart. The Date Range considers the dates associated with the field selected in the Date Field chart option.

Date Field: A 'Date' field is designed to store date and time values. For this chart option you'll choose a field that has a date or time value. For this example we are looking at incidents, so we want to see when the incidents were created. We use the Created (created_on) field. The date range is then looking for incidents created within the last 2 years.

Aggregate Type: Refers to a data aggregation method or function used to combine or summarize data from multiple records. They allow users to perform calculations on sets of records to derive meaningful insights. Some common aggregate types include:

Aggregate Field: refers to a field that displays an aggregated value based on the data from other fields. These fields are used to perform calculations or summarize data from related records.