Analytics: Bar Graph

Open your app that needs charts to be configured. Go to Design App > Analytics > Live Dashboard tab. By default there will already be some charts configured as examples. You can delete them if you wish. To add a new line chart, click on ‘Add chart’.

Help video

Configure Chart

After selecting bar graph from chart selection panel, you can configure the chart in 

right panel.

Following are the details of each field in right panel.

Chart title

Title of the chart. This can be empty.

X-Axis label

Label for x-axis of chart. This can be empty.

Y-Axis label

Label for y-axis of chart. This can be empty.

Aggregation

Chart data values can be aggregation of some field/module values or simply a count of submissions. This field is required.

Supported aggregation functions are

• COUNT
• SUM
• AVERAGE
• MINIMUM
• MAX

COUNT returns no of submissions. Other functions require an operand which can be one of the app fields. For more details refer to the example in the last.

X-Axis dimension

Data is grouped by the values of this field. This can be one of the app fields, status, submission creation time, submission modification time. This field is required. For more details refer to the example in the last.

This chart type also segregates data periodically into daily, weekly, monthly, or yearly (DWMY) intervals. This functionality is available only when a date field is selected as the X-Axis dimension. You can use either a custom date field from your app or the default "Created At" variable, which captures the submission creation date.

Additional Dimension

Data can be further categorized by providing this dimension. This can be one of the app fields, status, submission creation time, submission modification time. This field is required. For more details refer to the example in the last.

Example

Consider following data for an order details app. Each Order can be Order Delivered, In Transit, Order Placed or Pending Payment state.

‍

1 - Consider a bar chart for number of orders each date. The Aggregation will be COUNT and X-axis Dimension will be Order Date. It will look like this

‍

2 - Consider a bar chart for amount of orders in different state each day. The Aggregation will be SUM of Order Amount field in app, X-axis Dimension will be Order Date and Additional Dimension will be status. It will look like this

‍

‍

Using Filters

Filters can be applied to change input data to charts in submissions view. For example, in chart 2 after applying status filter, submissions table and charts are updated.

‍