Using different Start dates

[#1]

Hi,

I have a requirement wherein two dashboards are to be developed

one of which must have its date starting with 1-Jan-2010 and the  last date as today's date

other dashboard must have  the start date as start date  of the current week and the end date as last date of the current week.

Note: Both the dashboards will be referring two different date fields

Please let me know how this could be achieved in the same applications.

[jagan]

Hi,

Filter the records in Dashboard like below

Dashboard1:

Data:

LOAD

*

FROM DataSource

WHERE DateDimension1 < Today();

Dashboard2:

Data:

LOAD

*

FROM DataSource

WHERE DateDimension2 >= WeekStart(Today()) AND DateDimension2 >= WeekEnd(Today()) ;

Note: Replace DateDimension1 and DateDimension2  with your actual date fields .

Regards,

Jagan.

[#3]

You can try creating Sheet trigger to limit the data set.

For the Main Dashboard, OnActivate, you can set the DateField to be from 01-Jan-2014 to Today()

And for next tab say Weekly Data, you can set DateField from current week to last date of the current week.

Hope this was helpful

Thanks,

Singh