Forum Discussion

android1's avatar
android1
Post Patron
7 years ago
Solved

Count Distinct but only SUM different numbers

Hi,   I want to sum the number of distinct times a number in Visit Num column occurs.  In pic below for e.g 250884 occurs twice. I only want to count this once & display a total sum. Using distinct...
Need Help
  • Chihiro's avatar
    Chihiro
    7 years ago

    Are you using Table visual? If so, change it to Matrix visual.

     

    Put [Visit Num] into Row field. Add measure DISTINCTCOUNT([Visit Num]) as value field.

Chihiro's avatar
Chihiro
Solution Sage
7 years ago

Are you using Table visual? If so, change it to Matrix visual.

 

Put [Visit Num] into Row field. Add measure DISTINCTCOUNT([Visit Num]) as value field.