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

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.

Let's assume 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. 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". Picture
  2. Click "Save" on the upper left side of the screen.

Once the configured sum condition is applied to the app, the following summarized result is displayed: Picture