How to restrict only one value from dimension in a chart

[#1]

Hi

i have a Bar chart and in want to do this :

Count distinct on (type custome) , and i want to do it only on a specific cuatomer_id .

How do i restrict specific  value from Customer dimension in a chart ?

Thank you

[#2 · Accepted solution]

=count({1<Customer_ID={'YOURSPECIFICID'}>} customers)

[#3]

Hi

first thank you it works

but i don't understand how ?

what "1" stand for ?

where we did count distinct .

[#4]

sorry i forgot distinct

=count({1<Customer_ID={'YOURSPECIFICID'}>} distinct customers)

1 stands for that it is not affected by any selection.

I think you also could use $ cause your are specifiying what value it should be, so i does not matter.

[#5]

thank you

it been very helpful

[#6]

i found strange thing  !

when i use the this syntax in the graf  i get what i want.

but when i change the filter ( for example month)

the garf doesnt change ,why ?

[#7]

because you have set 1 infront. Try with $

one disregards the dimensions but not the selection..

and if that does not work

then try

=count({$<Customer_ID={'YOURSPECIFICID'}, MONTHCOLUMN=>} distinct customers)

[#8]

thank you again

[#9]

did it work?