Users love how customizable and powerful Grow is, but many of our customers don't want to touch any kind of SQL. Grow's transforms in Edit Metric let you filter, group, sum, and trim with ease.

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.

Remove Columns

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 removing columns, take a look at 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.

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.

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.

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.

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.

Time Shifting

The Time Shifting transforms lets you shift the timezone of your data. In Grow, data often comes 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 buttons (also called Slice and Dice 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?