Hi all,

I have a requirement that i have to display (shipment count-measure) WTD in a particular column if month is current month.

For eg: today is 13th sept 2016.

Week start date is sunday i.e 11th sept 2016.

month is september (i have to display WTD column for current month only)

For week start date:

TIMESTAMPADD(SQL_TSI_DAY,- DAYOFWEEK(MIN("- Shipment Period Dimensions"."Date")) + 1, MIN("- Shipment Period Dimensions"."Date"))

current date: CURRENT_DATE.

How to write a formula which calculates the shipment count for WTD?

====================================

I tried with to_date function but time dimension is not used for time series function because "TIME" is not checked in rpd. This is cloud instance i have no access to RPD to change.

Regards,

Ram.