Creating a Chart of Orders Received Per Month

Article Number:040747

In kintone, you can set up charts on the "Create Graph" screen of an app to display data by day, month, or year.

This article shows how to aggregate the monthly order data in an order management app and create a column chart like the one shown below.

Screenshot: A column chart showing the number of orders received per month

Suppose that the form has the following fields:

  • Order Date field
  • Order Amount field

Screenshot: The "Order Date" and "Order Amount" fields are outlined on a "Record Details" screen

In the steps below, we will create a column chart by aggregating the values in the "Order Amount" field and separating them by month based on the information in the "Order Date" field.

  1. On an app's "View" screen, click the Create Graph icon. Screenshot: The "Create Graph" icon is outlined

  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, by the month
    • Function: Sum, Order Amount
    • Filter: All records
    • Sort by (Level 1): Ascending Screenshot: The settings under "Graph Options"

  4. Click Apply.
    The orders received per month will be calculated and displayed in a chart.