How Do I Sum Distinct Counts?

[zijingxu]

Hi there,
How do I sum distinct counts over another column? I have attached a screenshot here, where I want to sum all the distinct counts of User IDs across all the Kit IDs. I tried sum(distinctCountOver({User ID},[{Kit ID}],PRE_AGG)) but does does not work and instead requires a ridiculously large number (screenshot also included).
Any help is appreciated!

[David_Wong]

Hi @zijingxu,

Can you try this?

sum(distinct_count({User ID}, [{Kit ID}]))

This calculates the distinct count of User ID grouped by Kit ID, and then calculates the sum of all those distinct counts grouped by the dimension present in your visual.

[zijingxu]

@David_Wong

sum(distinct_count({User ID}, [{Kit ID}]))

Yes it worked! Thank you so much.