Contrary to its name, the Group by transformation doesn’t work as expected in my scenario.
Here’s a picture of the query data:
We see that there are multiple metrics with equal names. About 7 for each series.
I’ve added a name filter just to make it easier to work with.
The Group by transformation shows the warning message Calculations will not have an effect if no fields are being grouped on.