limiting date dimension to last 7 days with conditional

[#1]

i'm trying to limit the date dimension to the last 7 days only, using a conditional.

something like that '>=today() -6'

how can i do that?

thanks,

Yaron.

[ashfaq_haseeb]

Hi,

Use this as a calculated dimension.

=if(DateField>=date(today()-6),DateField)

Regards

ASHFAQ

[#3]

there's still a column that shows totals even though the 'show total' option is off. how can i take it off?

[ashfaq_haseeb]

Hi,

Make sure suppress when values IsNull is Checked.

Regards

ASHFAQ