Example Chart Setting: Summing up the Sales Amount for This Month

Article Number:040584

This article shows how to configure data aggregation conditions to calculate the total sales for the current month in an app that contains product sales data.

Example of aggregated data: Screenshot: The total sales amount for the current month is displayed

Fields that need to be configured

Suppose that the app form has the following fields.

  • A "Date" field for entering the date of a sale
  • A "Sales amount" field for entering a sales amount for the day

Steps

  1. On the Graph settings screen, configure the settings under Graph contents.

    • Chart type
      Select Table.
    • Function
      Select Sum and "Sales amount".
    • Filter
      Specify the following condition:
      Date, = (equal), This month, All days Screenshot: Example of settings configured under "Graph contents"
  2. Click Save at the bottom right of the screen.

Once the configured aggregation conditions are applied to the app, the aggregated data will be displayed.