Hi Everyone,
we are noticing some weird issue with CJA data, we have created a calculated metric based of look up dataset dimension (using count distinct of dimension values) and the aggregate numbers are not matching with total numbers of rows with in that dimension, any idea what could be the possible reason for the discrepancy.
Since we are using "count distinct" of dimension values, our expectation is no of rows should be equal to aggregate numbers. any insight is highly appreciated