[FAQ000138]What is the difference between "Refine conditions before aggregation" and "Refine conditions of aggregation result" in the "Aggregate and output table data" action?

Q

What is the difference between "Refine conditions before aggregation" and "Refine conditions of aggregation result"

in the "Aggregate and output table data" action?

A

"Refine conditions before aggregation" is a condition to be used for aggregation.

"Refine conditions of aggregation result" is a condition to specify whether to display or not to display

with aggregate result.

For example, suppose we have a table with the following columns.

ID, store name, sales amount, sales start date, LAST_UPDATER, LAST_MODIFIED

If you want to display

only stores from this table whose "Sales start date" is January 2019 or later and whose "Total sales amount"

is 500,000 yen or more,

specify "Store name" as the "Aggregation key",

specify "[Sales start date] is greater than or equal to [01/01/2019] "In the "Refine conditions before aggregation" field,

and Specify "Sales amount (total) is greater than or equal to [ 500000 ]" for the "Refine conditions of aggregation result".