Skip to main content

Line Chart

Guidance on effectively utilizing line charts for data visualization and analysis, aiding decision-making processes.

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.

Monthly sales over 12 months for Furniture, Grocery, and Stationery. Grocery is the highest line throughout this example.


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.

Line Chart Data Source settings show Sales Management, the Sales list, and the Data Filters Setting button.

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.

Line Chart settings show Date grouped by Month, Product Category as the subcategory, and Sum of Sales. The second value is empty and disabled.

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

  1. Text Color: Set the color of the title.

  2. Typography: Set the typography of the title.

  3. Margin: Set the Margin of the title in PX , %, em, rem, vw, calc.

  4. Padding: Set the Padding of the title in PX , %, em, rem, vw, calc.

  5. Text Shadow. Set the shadow applied to the text.

Label

  1. Font Family: Set font family of the label.

  2. Size: Set font size of the label.

  3. Weight: Set font weight of the label.

  4. Style: Set font style of the label.

  5. Text Color: Set the color of the label.

Legend

  1. Font Family: Set font family of the legend.

  2. Size: Set font size of the legend.

  3. Weight: Set font weight of the legend.

  4. Style: Set font style of the legend.

  5. Line-Height: Set line-height of the legend.

  6. Text Color: Set the color of the legend.

Tooltip

  1. Background Color: Set the background color of the Tooltip container.

  2. Padding: Set the Padding of the tooltip container in PX , %, em, rem, vw, calc.

  3. Text Shadow. Set the shadow applied to the text.

  4. 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.

  5. 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.

The Tooltip Value panel has separate font family, size, weight, style, line height, and text color settings.


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.


​

Did this answer your question?