These are my three tables:
Transaction:
LOAD locationid,
trans_act,
Hour,
Soldon,
Location
FROM
(qvd);
Transaction_detail:
LOAD trans_act,
eventid,
itemid,
Event,
lastYearEventId,
FROM
(qvd);
MasterCalendar:
LOAD TempDate as Soldon,
Week(TempDate) as Week,
Year(TempDate) as Year,
Month(TempDate) as Month,
Day(TempDate) as Day,
Weekday(TempDate) as WeekDay
Resident TempCal
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:
- dimension: Hour
- expression: count(itemid)
How should I approach the camparison to lastYearEventId?
