Different Time Ranges

[evansabres]

I have sales data for several 'seasons'

There is a [Transaction Date] for each ticket sold.

What I want to do is have a time range of 0 - 100% to compare ticket sales across various seasons.

Is this possible?

[swuehl]

Something like

LOAD

     (TransactionDate - SeasonStartDate) / (SeasonEndDate - SeasonStartDate) as Percentage,

     ...

??

[evansabres]

Stefan -

Thank you. Question here would be that each season has a different start and end date, how would I account for that?

[swuehl]

Map your Transaction dates to the season date ranges.

For example, using IntervalMatch LOAD prefix or a mapping approach.

IntervalMatch

Don't join - use Applymap instead