The Analysis Group By provider in Data Sync takes a number of Data Sync project files as the source Data and applies grouping and aggregate functions to the results.
To get started, create your source data project and create any extra columns that you may need for the grouping. For example in the Sales Data example we have created a Calculated Column for Year and Month from the dateSold column.
To use this project as the source we then either create a new project and select this project as the source, or we can go to
Use Project with Analysis Grouping.
You now need to define the group/s and value columns. This is where Data Sync will group the rows, you can use multiple columns that define the group. In this example we have grouped by Year and Month, and returned the SUM of the units sold for each month within those years.
OK creates a new project with the current project as the source of the data, with the groups and value columns as the columns.
You can now use this as a Data source and normal and map the results to your target or simply export the results.