Dimension Last n days

[arsenal1983]

Hello,

On the barchart I would like to show only last n days from my data (dete dimension).

n is a variable (slider).

I don't want to use set analysis (becaouse there is no possibility to skip to the details data)

I don't want to use x-scrollbar

I would like to set the dimesion length - this should be simple but I'm walking around.

THX

Luke

[sunny_talwar · Accepted solution]

Not completely sure about your requirement, but may be something like this:

=If(Num(Date) <= Num(Today() - $(n)), Date)

and then select 'Suppress When Value is Null' option on the dimension tab of the chart properties.

[arsenal1983]

I knew it is simple but it is absolutely trivial,

Thanks Sunny.