currently I am building a dashboard that should function as a timeline. with this I mean: I have a few activities that are linked to a startdate. the startdate from the second activity however, is the enddate of the first activity.
the following example should explain it:
given is the following table:
now the activity 'Talking' starts at 1-1-2013 and ends at 20-1-2013, because then the activity 'Drinking' starts. The activity 'Drinking' ends on 22-2-2013 because then the activity 'eating' starts and so on.
so when I should click the date 15-1-2013, the activity 'talking' should be activated, and so on
i made this working with the following script:
NoConcatenate Load DISTINCT Date,
Month(Date) as CalendarMonth,
Day(Date) as CalendarDay,
Week(Date) as CalendarWeek,
Year(Date) as CalendarYear,
IF (Ceil(num(Month(Date)))/3 > 0, 'Q' & Ceil(num(Month(Date))/3), null()) AS CalendarQuarter,