Filter Dimension in Chart

[#1]

Seems a simple one but can't seem to find the answer. I have an order chart with all the order weeks running along the X axis but I only want to show those from the current week going forward. I already have the current week stored in another field.

Thought I'd try put something like [orderweek]>=[currentweek] in the dimension field but that didn't work. Can someone help?

[#2]

Hi,

can you transfer that current week into variable and compare value like [orderweek]>=[Variable name].

Thanks

piyush

[sushil353 · Accepted solution]

Hi,

I think below code should work:

if(orderdate>currentweek,order,null())

also check the option for suppress null values.

HTH

Sushil