Use a Line Chart to track a measure across time or another ordered category. For example, compare monthly sales by product category or count projects by start month.
Add Line Chart to the page
In the page designer, open Data Analytics and drag Line Chart into a section or container. Add a line chart to a dashboard
Select data source
Choose the data list whose records the chart should summarize. For example, use the Sales list for monthly sales or the Projects list for monthly project counts.
Open the Content > Data Source block, and in the Application section, select the application which is the current application by default.
Afterward, move on to the List section. Select the data list under the selected application.
In Data Filters, select Setting to choose which records contribute to the chart. For example, include only records from the reporting period.
Chart type, X and Y axis
Open the Content > Chart block to select the chart type and the fields as X-axis and Y-axis of this Line Chart.
Chart Type: select the chart type as Line Chart, or Area Chart.
X-axis (Category). Choose the horizontal grouping. For a monthly project trend, select Start Date and group by Month.
The sales example uses Date grouped by Month. Choose the date field for the event you want to measure.
X-axis (Subcategory). Choose an optional field such as Product Category to split sales into separate series. This disables Y-axis (Second Value).
Y-axis (Value). Choose a field and how to aggregate it. Select Id and Count for the monthly project count. The sales example uses Sales and Sum.
Depending on the field, available calculations can include Count, Sum, Count distinct, Avg, Max, and Min. Count distinct counts the different field values within each group.
Y-axis (Second Value). Choose an optional second measure, such as the sum of Cost alongside the sum of Sales. This disables X-axis (Subcategory).
Settings of Line Chart
Chart Height: Set the height of this Line Chart control.
Axis Line: Show/hide the line of Axis on the Line Chart.
Grid: Show/hide the grid line on the Line Chart.
Axis Labels: Show/hide the labels of X-axis and Y-axis.
Title of Line Chart
Display: turn on to show title of the Line Chart.
Chart Title: type the text of the title, or set dynamic content as the title text.
Title Position: set the display position of the title as Before Chart or After Chart.
Text Align: Set the alignment of the title as Left, Center, Right, or Justify.
Legend of Line Chart
Display: turn on to show Legend of the Line Chart.
Position: set the display position of the legend around the Line Chart.
Tooltip of Line Chart
Enable: turn on to show Tooltip of the Line Chart.
Number Suffix. Add a unit after the tooltip value. Use the unit of the selected measure.
Styling the Line Chart control
Title
Text Color: Set the color of the title.
Typography: Set the typography of the title.
Margin: Set the Margin of the title in PX , %, em, rem, vw, calc.
Padding: Set the Padding of the title in PX , %, em, rem, vw, calc.
Text Shadow. Set the shadow applied to the text.
Label
Font Family: Set font family of the label.
Size: Set font size of the label.
Weight: Set font weight of the label.
Style: Set font style of the label.
Text Color: Set the color of the label.
Legend
Font Family: Set font family of the legend.
Size: Set font size of the legend.
Weight: Set font weight of the legend.
Style: Set font style of the legend.
Line-Height: Set line-height of the legend.
Text Color: Set the color of the legend.
Tooltip
Background Color: Set the background color of the Tooltip container.
Padding: Set the Padding of the tooltip container in PX , %, em, rem, vw, calc.
Text Shadow. Set the shadow applied to the text.
Title: Set the Title's style of the Tooltip.
Font Family: Set font family of the Tooltip's title.
Size: Set font size of the Tooltip's title.
Weight: Set font weight of the Tooltip's title.
Style: Set font style of the Tooltip's title.
Line-Height: Set line-height of the Tooltip's title.
Text Color: Set the color of the Tooltip's title.
Value:Set the Value's style of the Tooltip.
Font Family. Choose the font family of the tooltip value.
Size. Set the font size of the tooltip value.
Weight. Set the font weight of the tooltip value.
Style. Set the font style of the tooltip value.
Line-Height. Set the line height of the tooltip value.
Text Color. Set the color of the tooltip value.
Advanced Settings
Set the Advanced options you need. Select Submit in the designer. Open the dashboard and compare the values with the filtered records. For monthly counts, check that a project falls in the expected start month.




