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
VasTg's avatar
VasTg
Memorable Member
6 years ago

ssharm43 

 

Is the "Distinct Count" in your sample the expected output or the entire visual on the right? 

 

You want to filter Flag=Yes and see the visual? Need more explanation.

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.