Distinct Count of Unique IDs

[LissieDomingo03]

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:

[raghuramSK]

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]

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