Scout Chart Creator
  • Overview
  • Get Started
    • Tutorial 1: NMR Daily Transaction Count
    • Tutorial 2: LPT Weekly Volume (USD)
    • Tutorial 3: NMR vs LPT Daily comparison
  • Pipeline
    • Filter
    • Project
    • Group
      • Accumulators
    • Sort
    • Unwind
    • Custom
  • Data Source
    • Transactions
    • States
    • Contracts
    • Aragon
    • Livepeer
    • dYdX
    • Set
    • Token holders
  • Operators
    • Math operators
    • Logic operators
    • Function operators
    • Array operators
    • String operators
  • Config
  • Protocols
    • Dodo
      • 24H trade volume
      • Deposit & Withdraw
    • Livepeer
    • dYdX
      • Making sense of the trade data
    • MakerDao
    • Pickle Finance
      • Example: Daily deposit and withdraw of jar 0.88
      • Example: Listing all borrows of a strategy
  • FAQ
    • Dealing with "logs" field in "Transaction"
    • How to handle "Query Timeout" error?
    • How to use a variable in a Pipeline
  • Research
    • The circulating supply of DODO tokens
    • How are bitcoins doing on Ethereum? (as of Jan 20th 2021)
Powered by GitBook
On this page

Was this helpful?

  1. Pipeline
  2. Group

Accumulators

push(field) Pushes the value of the selected field from a group into an array.

pushU(field) Pushes only the unique value of the selected field from a group into an array.

pushUC(field) Pushes only the unique value of the selected field from a group into an array in a cumulative way.

average(field) Returns the average of the values of the selected field from a group.

The field argument must be numeric. Non-numeric values or missing values will be ignored.

averageC(field) Returns the average of the values of the selected field from a group in a cumulative way.

The field argument must be numeric. Non-numeric values or missing values will be ignored.

sum(field) Returns the sum of the values of the selected field from a group.

The field argument must be numeric. Non-numeric values will be ignored.

sumC(field) Returns the sum of the values of the selected field from a group in a cumulative way.

The field argument must be numeric. Non-numeric values will be ignored.

max(field) Returns the maximum value of the selected field from a group.

The field argument must be numeric. If it has null or has no value at all, it will be ignored.

min(field) Returns the minimum value of the selected field from a group.

The field argument must be numeric. If it has null or has no value at all, it will be ignored.

first(sort, order) Returns the first document from a group. The group can be either sorted or not.

sort: Allows you to specify which field to sort. No sorting will happen if left empty.

order: 1 means ascending; -1 means descending. The default value is 1.

PreviousGroupNextSort

Last updated 4 years ago

Was this helpful?