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.

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.

Tag

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.

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.

Format Dates

Sometimes the data comes in formatted in a way that Grow won't recognize, which can then make it hard to use with other date-based transforms or chart formatting options. With this transform, you can help Grow recognize the parts of the incoming date format so it can reformat it into a standard YYYY-MM-DD format.