Forum Discussion
Helper ICompare Feature Sales with Previous Year Feature Sales
Impactful IndividualA few more questions ...
1. Are the input date and reservation dates two separate fields in the model?
2. Looking into next year, when you choose 23/12/16 which reservation dates in the next year do you expect to see?
3. Same question. Looking into last year, when you choose 23/12/16 which reservation dates in the last year do you expect to see?
Helper IHi to all and thank you for the thinking process...
I have a Calendar table that is based on the Reservation Date. All the revenue is based on the Reservation Date.
The revenue table has 2 date fields. Reservation and Input dates.
Business wise, looking into the next year asOf today the information is there, as reservations are coming in, I can look into the next year's revenue.
Looking into Last Year i must be able to filter this by Last Year's Input Date asOf 23/12/2015 and see what Revenue I had in 2016.
I can do this by having seperate graphs with seperate filters for Input Year. Graph 1 (Input Year <2017, Reservation Year 2017), Graph 2 (Input Year <2016, Reservation Year 2016).
Thus, I'm asking how I can combine this into one graph?
Thank you for your time.