Hi ALL,
i have this calendar srcipt:
Load
Date as Date,
Month(Date) as Month,
Year(Date) as Year,
Week(Date) as Week,
WeekDay(Date) as WeekDay,
Day(Date) as Day,
'Q'&Ceil(Month(Date)/3) as Quarter,
'H'&Ceil(Month(Date)/6) as HalfYear,
MonthName(Date) as YearMonth,
Year(Date) &'-Q'& Ceil(Month(Date)/3) as YearQuarter,
Year(Date) &'-H'& Ceil(Month(Date)/6) as YearHalfYear
resident Temp;
And when i put week as dimension , i can see only week number. I want to see Year, mont name and week number of month(for example, when i select 2014 year and Mar month i see only week numbers(see atch), my expected result is 2014 Mar 1, 2014 Mar 2,2014 Mar 3,2014 Mar 4 . How can i modifie calendar scrip? Please help
