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?