Hi everyone ,
i'm having a problem with my calendar especially january , the 1st start at the bottom (see attached photo)
This is my calendar that i'm using for the calendar please help
MasterCalendar:
LOAD *,
If(WeekDay <5, 1,0) as IsWorkingDay,
If(WeekDay = 5, 1,0) as IsSaturday,
If(WeekDay = 6,1,0) as IsSunday;
LOAD
TempDate AS start_date,
(Year(TempDate)*12+0) +(Month(TempDate)+0) as Cal_Link,
Year(TempDate) AS Year,
Day(TempDate) As Day,
Week(TempDate) as Week,
'Q' & Ceil(Month(TempDate)/3) as Quarter,
Month(TempDate) AS Month,
Weekday(TempDate) AS WeekDay,
inyeartodate(TempDate, maxdate, 0) * -1 AS CurYTDFlag,
inyeartodate(TempDate, maxdate, -1) * -1 AS LastYTDFlag
;
//=== Generate a temp table of dates ===
LOAD
date(mindate + IterNo()) AS TempDate
,maxdate // Used in InYearToDate() above, but not kept
WHILE mindate + IterNo() <= maxdate
;
//=== Get min/max dates from fact table ===/
LOAD
min(Date)-1 as mindate,
max(Date) as maxdate
RESIDENT Incidents;
Dimensions:
weekday
week
expressions:
= ' ' & Day
& chr(10) & chr(10) & concat(Country, chr(10))
