WTD calculation for shipment count

User_CEU9I

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.

Thomas Dodds

Get the RPD changed ... current setup isn't using the basic functionality of the BI server for which you've paid a lot of money for.