In OAC, this complex calculated metric is derived from two different datasets from separate data sources, joined through the product table. The individual calculations work correctly on their own, but when they are combined with a product filter, the results become inaccurate because the physical query changes the join behavior. The requirement is to calculate the average across all these derived calculations
Individually the values are coming as 1,4 when combined together in one visual its becoming inaccurate as 0,4
