Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
i have a problem with count()
my project language is Persian so maybe it's difficult to understand the problem. as you see in the picture i have four people with a "فشار خون بالا" disease but in chart count() show 8
i can't figure out what's the problem
i also load my qvw file if it helps.
i would appreciate if someone can help me.
Hi,
This is because your Join has created duplicate records.
The above chart is a tablebox which will not show you the duplicated records.
But in chart aggregation it will count even though its duplicate.
Regards,
Kaushik Solanki
or try with
sum(urfield)
or
count(agg(urfield))
Hi,
This is because your Join has created duplicate records.
The above chart is a tablebox which will not show you the duplicated records.
But in chart aggregation it will count even though its duplicate.
Regards,
Kaushik Solanki
i use distinct and it worked. Thank you
But Why records are duplicated, which part of my join is incorrect?