Transforming Data over whole Dataset

looking to see if I can perform aggregations over a whole dataset.

For example, Dataset A pulls in:
FC | Date | Function | Hours

Is it possible to aggregate on Dataset A so that the schema turns into:
FC | Date | sum(Hours)

then bring this aggregated Dataset A into Dataset B to join?

There’s no way to group rows by using an aggregation like sum unless you write a custom SQL query.

You can also use sumOver but it will write the sum in every row of your dataset.

1 Like