Bar Chart

The Bar Chart is used to display and compare different categories of data. The Bar Chart can work with the following aggregate functions: Count, Sum, Average, Min and Max.

Bar Chart

Bar Chart Settings

Note: The following examples use the Projects and Tasks Apps. See use case.

 

What are you comparing?

Average

Returns the average aggregate value for the selected Number Field.

 

Configuration

Bar chart average config

 

Result

Bar chart average
Count

Returns the number (count) of records for the selected App

The Count option is the only Bar Chart display option that returns the number of records. The Average, Maximum, Minimum and Sum aggregate options will only work on Number Fields.

 

Configuration

Bar chart count config

 

Result

Bar chart count
Maximum

Returns the highest (maximum) value for the selected Number Field.

 

Configuration

Bar chart maximum config

 

Result

Bar chart maximum
Minimum

Returns the lowest (minimum) value for the selected Number Field.

 

Configuration

Bar chart minimum config

 

Result

Bar chart minimum
Sum

Returns the total value for the selected Number Field.

 

Configuration

Bar chart sum config

 

Result

Bar chart sum

 

Grouping

Grouped by

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

 

Configuration

Bar Group config

 

Result

Bar Group
Then by

The Field used for adding an additional layer of grouping.

 

Configuration

First click on Add Grouping
Bar chart double grouping config
Then add the Field to group by
Bar chart double grouping config

 

Result

Bar chart double grouping
(Interval)

The interval is used for grouping by specific fragments of a date, such as the Year, Month or Day.

Note: The Interval setting will only be available when the chosen Grouped By Field is a Date.

 

Configuration

Bar chart interval config

 

Result

Bar chart interval

Bar Chart Formatting

Formatting lets you add additional styling options to the widget.

Orientation

Vertical
Bar Vertical
Horizontal
Bar Horizontal

Axis Labels

You can add labels that decribe your axis.

Configuration

Bar axis label configuration

Result

Bar axis label

Axis Range

You can set a minimum or maximum value for the Bar Chart's axis values. This can be used to visually enhance the difference between close data.

Configuration

Bar chart axis limit config

Result

Bar chart axis limit

Bar 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 Bar Chart widget to only take in consideration the Projects assigned to the logged in user, as shown below:

Bar chart filtering

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:

Dashboard filtering

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.

What would you improve in this article?