Analytics: Bar Graph

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.

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

1

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

2

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.