How to create a count distinct disregarding any dimension?

Question & Answer
,
1

Hi,
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 ?

Regards

2

You need to add PRE_AGG to the end of it.

distinctCountOver({id},[],PRE_AGG)
1 Like
3

Thanks, it’s works :+1: