Greetings,
I have aggregated transaction data using the Group By tile to produce the following schema:
Project ID (GROUP)
Amount (SUM)
Labor Cost (SUM)
I then join this dataset to a list of transactions which are also grouped by Project ID.
Left table = = Transaction dataset
Right table = = Grouped dataset from above
Joined on Project ID
Data types all match
When I preview the JOIN tile, I see only a fraction of the Amount (SUM) value from the above dataset for any given Project ID. However, if I connect the Group By tile to an Output tile and then select the resulting dataset as an Input tile for the JOIN, I see the expected Amount (SUM) value.
Any insights or thoughts appreciated from this great community. Thank you in advance.