keep variable value after filtering table/chart

[pgonin]

Hello everyone!

Would you please tell me, how can I store a value to variable so it doesn't change when I filter table?

Let's say I have a table 

LOAD * Inline [

name, value,

a, 1,

b, 2,

c, 3,

a, 2

];

 then I create a variable called "dist_names" which would count distinct names (3 in this case), and then, even if I filter this table or chart, the variable would remain the same (if I filter on "a", "b" the variable "dist_names" would still be 3, not 2)?

Thank you in advance!

[Anil_Babu_Samineni · Accepted solution]

Try this

Count({1} Distinct name)