Day

[Anonymous]

Hi,

I want to show first seven days starting from today in the X axis of a chart.(ex 28 to 4)

Actually I have a field named 'Day' which contains data from 1 to 31.

I tried taking calculated dimension as: if(Day>=day(today()) and Day<day(today()+7),Day), but it doesn't help.

Please suggest.

[sushil353]

Try this:

Sum({<Day={">=$(=Day(today())) <=$(=Day(today())+7)"}>}Sales)

or

Sum({<Datefield={">=$(=today()) <=$(=today()+7)"}>}Sales)

HTH

[Anonymous]

don't require sum of sales

[MK_QSL]

Use as below..

=Day(IF(YourDateField>= Today() and YourDateField< Today()+7, YourDateField))

Tick Suppress When Value is Null