Using calculated dimensions in charts/graphs

[lucasdavis500]

I'm using a calculated dimension one of my charts

=if(Model2.Month_Res = $(vTwoMonthLag), Model2.Month_Res)

On the charts themselves, the dimension seems to return "Null"

Is this the proper way to calculate a single month for a dimension??

where vTwoMonthLag =

"$(=Month(AddMonths(Date(Today()),-2)))"

[sunny_talwar · Accepted solution]

May be like this:

=If(Model2.Month_Res = Month(AddMonths(Today(), -2)), Model2.Month_Res)

[lucasdavis500]

That worked, I suppose having the variable in there added an extra '=' in

[sunny_talwar]

Yes that could have been the issue, but I am not sure how you have your variable setup and this is why gave you a direct expression without any variable

[lucasdavis500]

=if(Model2.Month_Res = $(vTwoMonthLag), Model2.Month_Res)

where $(vTwoMonthLag) = "$(=Month(AddMonths(Date(Today()),-2)))"

so it was definitely the variable, I have that variable stored for Set analysis, not use in a dimension

[buzzy996]

hi,I think u have to create tht variable in load script and u can use on ur chat,tht will work.