User Tools

Site Tools


transformations:start

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision
Previous revision
Next revisionBoth sides next revision
transformations:start [2021/06/20 19:48] – [Workflow / External] craigttransformations:start [2021/07/08 17:08] – [Transform / Math] dmitry
Line 24: Line 24:
 ==== Import / App & Cloud ==== ==== Import / App & Cloud ====
   * [[transformations:importairtable|Import from Airtable]] - import a table from Airtable.   * [[transformations:importairtable|Import from Airtable]] - import a table from Airtable.
-  * [[transformations:importpipedrive|Import from Pipedrive]] - import deals, organizations, persons from the Pipedrive CRM. 
   * [[transformations:importgoogleanalytics|Import from Google Analytics]] - import metrics from Google Analytics.   * [[transformations:importgoogleanalytics|Import from Google Analytics]] - import metrics from Google Analytics.
 +  * [[transformations:importpipedrive|Import from Pipedrive]] - import deals, organizations, persons from the Pipedrive CRM.
 +  * [[transformations:importwebapi|Import from Web API]] - import data from a Web API.
   * [[transformations:importgooglesheets|Import Google Sheets]] - import data from a Google Sheets spreadsheet.   * [[transformations:importgooglesheets|Import Google Sheets]] - import data from a Google Sheets spreadsheet.
   * [[transformations:importsharepointlist|Import SharePoint list]] - import a SharePoint list.   * [[transformations:importsharepointlist|Import SharePoint list]] - import a SharePoint list.
Line 102: Line 103:
  
 ==== Transform / Math ==== ==== Transform / Math ====
 +  * [[transformations:distributetotal|Distribute total]] - Break down a total/subtotal proportionally to a group of numbers (weights).
   * [[transformations:linearregression|Linear regression]] - Build a linear regression. Interpolate/extrapolate values if needed.   * [[transformations:linearregression|Linear regression]] - Build a linear regression. Interpolate/extrapolate values if needed.
-  * [[transformations:statisticalaggregation|Statistical aggregation]] - Calculate median, percentile, standard error, standard deviation, or variance. 
   * [[transformations:runningtotal|Running total]] - Calculate rank, cumulative count, sum or % from total sum.   * [[transformations:runningtotal|Running total]] - Calculate rank, cumulative count, sum or % from total sum.
 +  * [[transformations:statisticalaggregation|Statistical aggregation]] - Calculate median, percentile, standard error, standard deviation, or variance.
   * [[transformations:subtotal|Total/subtotals]] - add column total or group subtotals as a new column.   * [[transformations:subtotal|Total/subtotals]] - add column total or group subtotals as a new column.
  
transformations/start.txt · Last modified: 2024/04/12 00:30 by craigt

Donate Powered by PHP Valid HTML5 Valid CSS Driven by DokuWiki