Calculating Monthly Order Amount

Article Number:040747

In kintone, you can easily create a chart of an aggregate result (daily/monthly/yearly result) just by selecting an item in the screen.

This page describes the steps to calculate monthly order amount in an app where you manage orders and display the calculation result in a column chart.

Image

Suppose that the form has the following fields:

  • Order Date field
  • Order Amount field

Image

Perform data aggregation on the values in the Order Amount field, and categorize the result by months based on the information entered in the Order Date field, and then display the data in a column chart.

  1. On an app's "View" screen, click the Create Graph icon. Image

  2. From Design a Graph Starting from Graph Type, click Column chart.

  3. Specify each item.

    • Chart Type: Column chart, Clustered
    • Group by (Level 1): Order Date, Monthly
    • Function: Total, Order Amount
    • Filter: All records
    • Sort by (Level 1): Ascending Image

  4. Click Apply.
    Monthly order amount is calculated and displayed in a graph.