Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
Something like
LOAD
(TransactionDate - SeasonStartDate) / (SeasonEndDate - SeasonStartDate) as Percentage,
...
??
Stefan -
Thank you. Question here would be that each season has a different start and end date, how would I account for that?
Map your Transaction dates to the season date ranges.
For example, using IntervalMatch LOAD prefix or a mapping approach.