General Principles
            
          
            
            
            
              Add Missing Dates
            
          
            
            
            
              Add text column
            
          
            
            
            
              Add Total Rows
            
          
            
            
            
              Aggregate
            
          
            
            
            
              Append
            
          
            
            
            
              Compare Text Columns
            
          
            
            
            
              Argmax
            
          
            
            
            
              Argmin
            
          
            
            
            
              Concatenate columns
            
          
            
            
            
              Convert
            
          
            
            
            
              Convert date to text
            
          
            
            
            
              Convert text to date
            
          
            
            
            
              Cumulated sum
            
          
            
            
            
              Custom step
            
          
            
            
            
              Delete column(s)
            
          
            
            
            
              Geographically dissolve data
            
          
            
            
            
              Duplicate
            
          
            
            
            
              Duration
            
          
            
            
            
              Evolution
            
          
            
            
            
              Extract date information
            
          
            
            
            
              
            
          
            
            
            
              Extract substring
            
          
            
            
            
              Fill null
            
          
            
            
            
              Filter
            
          
            
            
            
              Formula
            
          
            
            
            
              Geographical hierarchy
            
          
            
            
            
              Get unique groups/values
            
          
            
            
            
              Hierarchical rollup
            
          
            
            
            
              ifthenelse
            
          
            
            
            
              Join
            
          
            
            
            
              Keep column(s)
            
          
            
            
            
              Moving Average
            
          
            
            
            
              Percentage
            
          
            
            
            
              Pivot
            
          
            
            
            
              Rank
            
          
            
            
            
              Rename
            
          
            
            
            
              Replace
            
          
            
            
            
              Geographical simplification
            
          
            
            
            
              Sort
            
          
            
            
            
              Split column
            
          
            
            
            
              Column's Statistics
            
          
            
            
            
              To lowercase
            
          
            
            
            
              To uppercase
            
          
            
            
            
              Top N rows
            
          
            
            
            
              Unpivot
            
          
            
            
            
              Waterfall
            
          
        
      Custom step
You can use this step to write your own query.
This step is supported by the following backends:
- Mongo 5.0
 - Mongo 4.2
 - Mongo 4.0
 - Mongo 3.6
 
Where to find this step?
- Widget 
Add - Search bar
 
Options reference

For Mongo, you are expected to write an Aggregation Pipeline query. Please see the dedicated documentation for more information.
Example

This configuration results in:
