Line Chart

The Line Chart helps you visualize a trend in data over intervals of time. The Line Chart can work with the following aggregate functions: Count, Sum, Average, Min and Max.

Line Chart Settings

What are you comparing?

Average	Returns the average aggregate value for the selected Number Field. Configuration Result
Count	Returns the number (count) of records for the selected App The Count option is the only Line Chart display option that returns the number of records. The Average, Maximum, Minimum and Sum aggregate options will only work on Number Fields. Configuration Result
Maximum	Returns the highest (maximum) value for the selected Number Field. Configuration Result
Minimum	Returns the lowest (minimum) value for the selected Number Field. Configuration Result
Sum	Returns the total value for the selected Number Field. Configuration Result

Grouping

Grouped by

The Field used for grouping by record values plotted in the Line Chart.

Configuration

Result

Then by

The Field used for adding an additional layer of grouping.

Configuration

Line chart double grouping config — First click on Add Grouping

Result

Line Chart Formatting

Formatting lets you add additional styling options to the widget.

Orientation
Line	Area

Line Chart Filtering

You can apply two types of data filtering: widget filtering and saved views.

Widget filtering should be applied as a base filter.

For example, you might want a Line Chart widget to only take in consideration the Deals that are set as closed, as shown below:

Note: Widget filtering will be applied to all users.

Saved views can then be applied on the whole dashboard (unlike widget filters, that are applied per widget) and you can, for example, show only ongoing Projects, as shown below:

Note: Saved views are applied on top of widget filters. Unlike widget filtering, saved views are only applied to the user in context. You can share them with other team members.

Was this article helpful?

Yes 😃 No 😞

Thanks for your feedback!