You can use SQL to transform data but you don’t have to. You can also use the Filtering, Grouping, and Aggregation options. To filter click Filter Data, Add Filter, select the column you want to filter on. Enter your filter criteria. You can group the data, by selecting the column you want to group and the criteria. Make sure you add aggregation if you want totals. We can also add an average and then create a Goal Line based on that average. Many of the transformations that used to take SQL can now be done using the tools.

Did this answer your question?