Duaer

Snippets

Group, sum, and count items in Duaer (like a pivot table)

In Duaer, the Summarize node groups items by region, customer, or category and returns sums, counts, and averages without code.

Group and total in Duaer

  1. Add Summarize.
  2. Under Fields to Summarize add an entry with Aggregation Sum and Field amount. Add more as needed, such as Count of order_id or Average of amount.
  3. Set Fields to Split By to the group field, such as region; separate several with commas.
  4. Select Execute step. You get one item per group, with the total in sum_amount and counts in fields like count_order_id.

Aggregations: Append, Average, Concatenate, Count, Count Unique, Max, Min, Sum. Add Sort to rank by total and Convert to File to export.

When the sum is wrong

Amounts stored as text such as "1,280.50" do not sum. Convert them in Edit Fields first: {{ Number(String($json.amount).replace(/,/g, "")) }}, type Number.

Questions

Can Duaer summarize like an Excel pivot table?

Yes. The Duaer Summarize node groups by Fields to Split By and computes sum, count, average, and more under Fields to Summarize.

What is the total field called in Duaer Summarize?

Duaer names it aggregation_field, such as sum_amount or count_order_id.

In this section

Nodes

Summarize fields in Duaer

In Duaer, Summarize sets Aggregation (default Count) and Field under Fields to Summarize. Use Fields to Split By to group.

Nodes

Sort items in Duaer

In Duaer, Sort reorders the current items by field. Type can be Simple, Random, or Code.

Office tasks

Categorize bank statement lines and total them by category with Duaer

In Duaer, upload a bank statement, let Duaer Judgment put each transaction into categories you define, then export the lines and totals per category.

Snippets

Split an array into separate items in Duaer

Duaer nodes run once per item. Split an order line list or an API array into one item per entry with Split Out so the next nodes handle each one.