CJA Question - Aggregate number not matching with no of rows | Community
Skip to main content
M
Mohan_KrishnaTu
Level 2
February 23, 2024
Question

CJA Question - Aggregate number not matching with no of rows

  • February 23, 2024
  • 1 reply
  • 509 views

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

 

 

 

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

1 reply

kautuk_sahni
Community Manager
kautuk_sahniCommunity Manager
Community Manager
October 18, 2024

@tof_jossic @yuhuisg @nnakirikanti @anuhya-y @satheeskannak @brekrut Curious to hear SMEs perspectives on this question. Do you all mind sharing your thoughts?

Kautuk Sahni
Terms & ConditionsAccessibility statement

Loading footer...