Example Chart Setting: Summing up the Sales Amount for This Month
In the app that has the amount of product sales entered, configure the conditions so that the amount of sales for this month is calculated.
Suppose 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
- In the graph setting screen, specify each item in "Graph Contents".
- Chart Type
Select "Table". - Function
Select Sum and "Sales Amount." - Conditions
Specify the following condition:
"Date" "= (equal)" "This Month" "All"
- Chart Type
- Click Save on the upper left side of the screen.
Once the configured aggregation condition is applied to the app, the following aggregate result is displayed: