Expand my Community achievements bar.

CJA Question - Aggregate number not matching with no of rows

Avatar

Level 2

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

mtummala54_0-1708650692121.png

 

mtummala54_1-1708650823136.png

 

 

0 Replies