Chart Scripting? Help

[Anonymous]

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?

[robert_mika]

Could you add your data/app?

[Anonymous]

Here is my app and some example data