Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Try this:
Sum({<Day={">=$(=Day(today())) <=$(=Day(today())+7)"}>}Sales)
or
Sum({<Datefield={">=$(=today()) <=$(=today()+7)"}>}Sales)
HTH
don't require sum of sales
Use as below..
=Day(IF(YourDateField>= Today() and YourDateField< Today()+7, YourDateField))
Tick Suppress When Value is Null