Trouble with variables and date selection

[#1]

I have a formula that I turned into a variable called vUsers

vUsers = count(distinct(users)

Then I have a chart where I add vUsers as an expression

when it's applied, and I use the date filters the value is displaying on all Months in my chart as well as Quarters when Quarters is selected. Not sure why since I only have 1 month of data loaded. It's the same value across all the months when I have the year selected.

Anyone know what I'm doing wrong here?

[#2]

Hi,

try writtning your variable (in expression) like this: $(vUsers) .

Best regards.

[#3]

Nope. Unfortunately same thing

[#4 · Accepted solution]

John,

DId you declare variabe in "Variable Overview"?

if your answer is Yes... select ypur variable and delete symbol "=" then write your varible in chart $(vUser).

See the imagine

.

Best regards.

[#5]

Bingo. Oswaldo. That worked. Now, why would that make a difference? Just so I understand it?

[#6]

Jeje to be honest... I don't know, just try and error  :S (experience I guess)

Regards.