Forum Discussion
Valentb
Advocate I
Advocate IDistinctCount - aggregation - not working - I'm lost
Hi there! I've been struggling with distinctcount per transaction_id when trying to use an agg.table. It's been more than 7 months since this issue came to light, but I cannot see a solution, and...
AnushaSri
Resolver II
Resolver IIHi,
1. Have you had a look into the data types of Fusion_key in both fact and agg tables? - some times creating a relation on different data types might create issue.
2. On your Red Arrow you are pointing at Cout of transaction id with actual transaction id , could not understand much, but if you are trying to create a relationship then its not a valid realation as one is id and one is count.