This content has been marked as final. Show 2 replies
These are my three tables:
LOAD TempDate as Soldon,
Week(TempDate) as Week,
Year(TempDate) as Year,
Month(TempDate) as Month,
Day(TempDate) as Day,
Weekday(TempDate) as WeekDay
Order by TempDate ASC;
I want to create a chart that will reflect an hourly count of items sold in a particular WeekDay, for an Event and compare it, in the same chart, to an hourly count of items sold on the same WeekDay (that will be a different date), for the lastYearEventId.
I had it working without comparing it:
How should I approach the camparison to lastYearEventId?