Example Chart Setting: Creating a Chart by Categorizing the Amount of Product Sales by Product Category and then by Product Name

Article Number:040585

This article shows how to configure data aggregation conditions for an app that contains product sales so that total sales amounts are calculated by product category and product name, in that order.

Example of aggregated data: Screenshot: A column chart showing total sales amounts by product category and by product name.

Fields that need to be configured

Suppose that the app form has the following fields.

  • A "Product category" field for entering product categories
  • A "Product name" field for entering product names
  • A "Sales amount" field for entering product sales amounts

Steps

  1. In the graph setting screen, specify each item in "Graph Contents".

    • Chart type
      Select Column chart and Stacked.
    • Group by
      Select "Product category" for Level 1 and "Product name" for Level 2.
    • Function
      Select Sum and "Sales amount". Screenshot: Example of "Graph contents" settings
  2. Click Save at the bottom right of the screen.