TimeDIM: LOAD DISTINCT DateTime, Year(DateTime) as Year, MonthName(DateTime) as Month, WeekStart(DateTime) as [Week Beginning], date(dayname(DateTime),'MMM-DD') as Day, WeekDay(DateTime) as Weekday, makedate(year(DateTime),month(DateTime),day(DateTime)) as Date, Hour(DateTime)&':00' as Hour, ApplyMap('hour_temp',Hour(DateTime)&':00' ) as hour_sort, Minute(DateTime) as [Minute of Hour], timestamp(floor(DateTime,1/(24)),'MMM-DD hh:00') as [Hour Timeline], If(DateTime>=43650.77912037,1) AS last7days, If(DateTime>=43643.77912037,1) AS last14days, If(DateTime>=43629.77912037,1) AS last28days, If(DateTime>=43567.77912037,1) AS last90days resident tempDateTimeList
