Forum Discussion

ssharm43's avatar
ssharm43
Helper I
6 years ago

Distinct count with group column

Hi everyone, I do not know if I am posting on apropiate platform, pardon me if I am wrong. I am looking for a solution where I have distinct records but I am looking to calculate distinct Id with f...
Need Help
ssharm43's avatar
ssharm43
Helper I
6 years ago

Yes, I want on visual like visual card, and It is like overall distinct count. 
situation is like:

 

Distinct count of "ID" if "flag" is "Yes" is for any of the "cases", i.e count the Id only once, negelect the "No" from flag and
Distinct count of "ID" if "flag" is "No" is for all the "cases", i.e count the Id only once.

 

Hope you understand now.

dax's avatar
dax
Community Support
6 years ago

Hi ssharm43 , 

I am not sure whether what is your detailed requirement, you could refer to my sample for details. If this is not what you want,please correct me and inform me more detailed information(such as your expected output and your sample data)? Then I will help you more correctly.

Please do mask sensitive data before uploading.

Thanks for your understanding and support.
Best Regards,
Zoe Zhi

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.