You can aggregate an app's record data (e.g., numeric values, a number of records) and create a chart from the data. If you save your chart settings, you can use them any time to display a chart with the latest data on the app's main page (the View screen).
To save chart settings, you need to have app management permission.

In Kintone, you can perform data aggregation in either of the ways described below and turn the data into a chart or table.

• Design a graph starting from graph type
  Create a chart or table by specifying a chart type and aggregation conditions.
• Use a recommended graph
  Chart/table suggestions are automatically generated based on your app data.
  Create a chart or table by selecting the suggestion that meets your needs.

For details on the different types of charts and how they can be used, refer to the following page.
Chart types and their usage

This section describes the steps to create a chart from the View screen.
Here, you will create a chart that displays the monthly sales amount for the year using the "Received Order (Real-time)" app, which is used for managing order dates and amounts. When creating a chart, you will select a chart displayed under Design a graph starting from graph type.

Image of the created chart

1. On the app's View screen, click the Create graph icon.

2. Select the chart type from the options displayed under Design a graph starting from graph type.
   In this example, select Column chart. Reference: Chart types and their usage

3. In the Chart type section, select how to display your aggregated data.
   In this example, select Clustered.

4. In the Group by section, configure the grouping used for the chart.
   In this section, you can specify the following three items: Level 1, Level 2, and Level 3 items. The fields for Level 2 and Level 3 items appear when you click the plus sign-shaped Add icon at the bottom of the Group by section.
   Since you want monthly sales data to be aggregated, specify "Order Date" and "by the month" for Level 1 and "Product Name" for Level 2.
   If you configure Level 1 and Level 2 items for a column chart, the Level 1 item will be displayed on the horizontal axis and the Level 2 item will be used as data series. You can check the preview of the chart on the screen.
   

5. In the Function section, select one or more functions to specify how you want the data to be aggregated.
   You can select functions from the options Count, Sum, Average, Maximum, and Minimum.
   Since you want to calculate the total sales amount, select Sum for the function and "Price" for the field whose values are to be aggregated.
   In the case of a clustered column chart, the selected function is applied to the vertical axis.

6. Configure the settings in the Filter section.
   You can configure filter conditions when you want to limit the scope of data aggregation to certain records (e.g., when you want to set a date range for the data subject to data aggregation). You can click Clear all to clear all of the conditions that have already been added.
   Since you want the sales amount for this year to be aggregated, select "Order Date", = (equal to), and This year.
   

7. In the Sort by section, configure the ordering of the aggregate result.
   You can select the items used for sorting from the options Total, Level 1, Level 2, and Level 3.

   • If you select Total: Data on the chart is sorted based on the result of aggregation carried out in accordance with the setting in the Function section, which you have configured in step 5. You can select either ascending or descending for the sort order.
   • If you select Level 1, Level 2, or Level 3: Data on the chart is sorted based on the values of the field specified in the Group by section, which you have configured in step 4. You can select either ascending or descending for the sort order.
     In this example, select Ascending for both Level 1 and Total.
     

8. Click Save as new graph or Apply.

9. If you clicked Save as new graph in step 8, name the chart and save it. After doing so, the chart you created will be displayed.
   If you click Apply, the chart you created will be displayed.

You have successfully created a chart that shows aggregate results.

By clicking the item names (data series) on a chart, you can change whether to show/hide individual items.
This is useful when you want to compare specific items on a chart to further analyze the displayed result.

By clicking an individual aggregate result, you can display a list of records included in the result.
This is useful when you want to check which record data has been aggregated.

For example, say you click the bar in a chart that represents the sales data for "Apple Pie" in October.

Doing so displays a list of only records that meet the criteria (October, "Apple Pie").
The fields displayed in the list and their ordering are the same as those in the default view (the view placed at the top of the view list on the Views tab of the App settings screen).
Reference: Changing the default view