Grow's Data Transform Pipeline lets you add these transforms in any order. You can read this article to learn more about it.

Here is a brief overview of what each button does, going from top to bottom in the transform list.

Filter Data

Here you can select a specific column, and filter the information based on the data. Incredibly helpful to show data containing a specific keyword, or remove data that is not within a certain range. 

This article has more info on how to filter your data.

Group Data

This button lets you immediately aggregate grouped data from certain cells within your report. This is great for grouping data by week or month.

To learn more about how to group your data, check out this article.

Sum, Count, Average, Min, Max

This one is pretty self-explanatory. You can perform these actions (sum, count, average, min, or max) based on a column of your choosing.

To learn more about the Sum, Count, Avg, Min, Max transform, check out this article.

Calculated Columns

Calculated columns allows you to do math between two or more fields, change the format of a date, or extract a substring to display valuable information on your table charts. 

Check this article out to learn more about calculated columns.

Sort Data

You can sort all of the data from the report based on a specific column. Ascending and Descending by number or alphabet. 

Use this article to learn more about sorting your data.

Write SQL

Should any of the other transforms not meet your needs, SQL can be a powerful tool when you need something specific from your data. Use this transform to write your own SQL to manipulate your data.

Use this article to learn more about sorting your data.

Select Column

This allows you to select which columns you want displayed. This can be particularly helpful when you have dozens of columns and want to focus on two or three at a time.

To learn more about selecting columns, take a look at this article.

Pivot Table

Pivot tables take your data and combine different factors on your data and display it in a new table. It can sort, count, unique count, average, or find the min or max of your data. This gives you a lot of flexibility and analytical power to extract the significance from detailed data sets. 

Learn more here on how to use pivot tables.

Rename Column

If you'd like to customize the column names in your data to something of your choosing, you can use the Rename transform. This allows you to select an existing column, and then specify a new name.

Click here to learn how to rename your columns.

Compare Dates

The Compare Dates transform allows you to compare your data across two different periods of time. This also ensures that your date ranges can update dynamically, meaning your metrics will stay updated instead of having to hard code in custom date ranges. 

Learn more here on how to use the Compare Dates transform.

Tagging

The Tag transform allows you to create custom groupings categories which you can then apply to your data. It will create a new column with the tagged names you've created based on the criteria you select.  

Use this article here to learn more about the Tag transform.

Time Shifting

The Time Shifting transform lets you shift the timezone of your data. In Grow, data often comes in as UTC time, but that doesn't work for a lot of our customers. So we've added this transform so you don't have to write SQL to shift your data.

Check out this article to learn more about Time Shifting.

If you do need to use Master SQL or SQL with the transform tools, more info can be found here

Questions about the transform buttons? Email us at support@grow.com or chat in on the site.

Did this answer your question?