Need Help : How can I make change my "input zone" with Date(Today() - X)

[#1]

Hi,

How can visualize my table with StartDate = Date(Today() - X)

X is a variable that can change.



For example : Date(Today() -3), I can see all records of 26/11/2012.

Thanks for your help.

Judi.

[vgutkovsky]

Judi,

See attached. You can also modify the set analysis to select >= if that's your business rule.

Regards,

Vlad

[swuehl]

Just create an input box with a numeric range and assign the selected value to a variable X or vVar.

Then, you'll need a straight table, a simple table box doesn't allow to use calculated dimensions / expressions.

In a straight table (or any other chart except the table box), create a calculated dimensions:

=if([Start Date]>=today()-vVar,[Start Date])

Maybe add your other dimensions, and maybe as expression add a =sum(Sales).

That's all (see attached).

Instead of the calculated dimension, you can use a set expression or condition with all your expressions (there are plenty of demos in the forum on how to do this).

Regards,

Stefan

[#4]

Thank for your help.

Could you please verify my expression, I have some difference.

When I select 19/06/2012 on my listbox, I visualize 6 records on

19/06/2012.

When I use my input zone with X=163. The date is 19/06/2012, reocords 6

lines in result but my list shows others date different of 19/06/2012.

Thanks,

[#5]

Thanks a lot.

It works !!

I was some trouble into my model.

Judi.