How to create a count distinct disregarding any dimension?

I’m fighting on a (I thought so) simple calculation.
I use a simple count distinct : distinct_count({id}) and it’s OK.

Now, I’d like to calculate a count distinct in a visual disregarding any dimension of the visual
I tried distinctCountOver({id},) and it doesn’t works.

Can you please help me ?


You need to add PRE_AGG to the end of it.

1 Like

Thanks, it’s works :+1: