Hi,
I'm about to create a calendar(see below) that will show when airplane lands and starts. I use a calendar but it is not sufficient when the user wants to see the number of landings / take-offs per hour. To make it even more complicated the user would be able to choose at the scheduled time and actual time. The mastercalendar works fine, but I want to get the hours too.
Both the planned time and actual time includes hh: mm: ss.
I hope that someone out there sitting on the solution or can link me to the forum there a solution exists.
LET StartDate = num(date(YearStart(AddMonths(Today(),-36,0)),'YYYY-MM-DD'));
//LET EndDate = num(date(YearEnd(AddMonths(Today(),0,0)),'YYYY-MM-DD'));
LET EndDate = num(date(today(),'YYYY-MM-DD'));
LET CurrentDate=num(date(Today(),'YYYY-MM-DD'));
LET CurrentYear=Year(Today());
LET LY_YTD=num(AddMonths(Today(),-12,0));
LET DaysToEnd=Monthend(Today())-Today();
//LET Today = date(today(),'YYYYMMDD');
DateIsland:
LOAD
*,
Year(Date) AS [year],
Month(Date) AS [month],
num(Week(Date),00) as [week],
Day(Date) AS [day],
WeekDay(Date) AS [weekday],
Date(Monthstart(Date),'MMM-YY') as [Year Month], // calculates YearMonth in the format MMM-YY
Dual(WeekYear(Date)&'W'&num(Week(Date),00),WeekYear(Date)&num(Week(Date),00)) as [Year Week],
Dual('Q'&Num(Ceil(Num(Month(Date))/3)),Num(Ceil(NUM(Month(Date))/3),00)) as [quarter],
if(InYear (Date, $(CurrentDate), -1),1) as _FULL_LY,
if(InYear (Date, $(CurrentDate), 0),1) as _FULL_TY,
if(InYearToDate (Date, $(CurrentDate), 0),1) as _YTD_TY,
if(InYearToDate (Date, $(CurrentDate), -1),1) as _YTD_LY,
if(InQuarter (Date, $(CurrentDate), 0),1) as _FULL_TQ_TY,
if(InQuarter (Date, $(LY_YTD), 0),1) as _FULL_TQ_LY,
if(InQuarter (Date,$(CurrentDate), -1),1) as _FULL_PRQ,
if(InQuarterToDate (Date, $(CurrentDate), 0),1) as _QTD_TY,
if(InQuarterToDate (Date, $(LY_YTD), 0),1) as _QTD_LY,
if(InQuarterToDate (Date,$(CurrentDate), -1),1) as _PR_QTD,
If( InMonth (Date, $(CurrentDate),0),1) as _FULL_TM_TY,
If( InMonth (Date, $(CurrentDate),-12),1) as _FULL_TM_LY,
If( InMonth (Date, $(CurrentDate), -1),1) as _FULL_PRM,
If( InMonthToDate (Date, $(CurrentDate),0),1) as _MTD_TY,
If( InMonthToDate (Date, $(CurrentDate),-12),1) as _MTD_LY,
If( InMonthToDate (Date, $(CurrentDate), -1),1) as _PR_MTD,
// Week
If( InWeek (Date, $(CurrentDate),0),1) as _FULL_TW_TY,
If( InWeek (Date, $(LY_YTD),0),1) as _FULL_TW_LY,
If( InWeek (Date, $(CurrentDate), -1),1) as _FULL_PRW,
If( InWeekToDate (Date, $(CurrentDate),0),1) as _WTD_TY,
If( InWeekToDate (Date, $(CurrentDate), -1),1) as _PR_WTD
//where exists(Date,Date)
//Takes only dates in transtable alt. booking date in GL
;
Load
Date($(StartDate)+(Iterno()-1),'YYYY-MM-DD') as Date
// Date, to be used as key feild to transactions
Autogenerate 1
While Date($(StartDate)+(Iterno()-1)) <=Date($(CurrentDate))
;
STORE Data INTO Data.qvd (QVD);
Thanks in advance,
Daniel
