Example of Setting Sum Conditions: Summing Up the Amount of Sales for the Current Month

In the app that has the amount of product sales entered, sum up all the amount of sales for current month.

Let's assume that the form has the following fields:

  • "Date" field with the sales date entered
  • "Sales amount" field with the amount of sales for that day
  1. On the "Record List" screen of an app, click Column chart icon.
    Image
  2. Click "Others" in "Design a Graph Starting from Graph Type".
  3. Specify each item.
    • Chart Type
      Select "Table".
    • Group by
      Select "--".
    • Function
      Select "Sum" and "Sales amount".
    • Filter
      Select "Date", "= (equal)", and "This Month". Image
  4. Click "Apply".

The following summarized result is displayed: Image