cancel
Showing results for 
Search instead for 
Did you mean: 

Distinct Count of Unique IDs

LissieDomingo03
Explorer
0 Kudos

Hi! Is there a way to count unique IDs? Example below:

  • ID 001
  • ID 001
  • ID 006
  • ID 005
  • ID 001

Total should be = 3 (instead of 5)

I tried this, but it isn't working:

Accepted Solutions (0)

Answers (2)

Answers (2)

raghuramSK
Product and Topic Expert
Product and Topic Expert
0 Kudos

Hello melissaanne

I am able to achieve it using the same setup.

My Data source is built on 'Job Information' object with 'User ID' as the Dimension. And filtered for only 5 User IDs.

  • I have used the same 'User ID' column in a Calculated Column and converted it into a Measure named 'Test'.
  • Formula used TONUMBER('User ID').

At designer level, I took a Chart widget and added 'Test' as Measure.

  • It showed, 1.9M records. Which is the total number of records these 5 users have.

I, then, created the below calculation:

I can now see the Unique Values for 'Aggregation 1':

Thanks,

Raghu

LissieDomingo03
Explorer
0 Kudos

Hi raghuram.singh.kshatri ! Maybe you know the answer to this as well? 🙂