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

Article Number:040585

In the app that has the amount of product sales entered, configure the conditions so that the amount of sales is calculated by product category and product name.

Suppose that the form has the following fields:

  • "Product category" field with the product category entered
  • "Product name" field with the product names entered
  • "Sales amount" field with the amount of product sales entered
  1. On the Graph settings screen, specify each item under 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.

Once the configured aggregation conditions are applied to the app, the following aggregate result is displayed. Screenshot: The configured chart is displayed