Forum Discussion
Helper ICompare Feature Sales with Previous Year Feature Sales
Helper ILet me explain the business case:
For example asOf today, 23/12/16 (Input Date) I have xxxxx Total Revenue for 2017 based on Reservation Date.
For Last Year, asOf 23/12/15 (Input Date) what I had in Total Revenue for 2016 based on Reservation Date?
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?
- asl10
Hi 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.
- Baskar
Resident Rockstar
Share some sample data , i will help u to achieve your goal
- asl10
Hi Baskar,
Thank you for your offer for help :)
For example you have the following table. You can construct and a calendar table based on the Reservation Date.
Input Date Reservation Date Revenue 01/01/2015 02/02/2016 250 10/05/2015 03/04/2016 100 11/11/2015 10/12/2016 300 27/12/2015 11/11/2016 500 03/04/2016 10/10/2017 100 05/10/2016 05/05/2017 400 20/12/2016 23/12/2017 585 23/12/2016 10/10/2017 100 Thus the goal is to have a graph with 2 bars side-by-side were if you see the data asOf today 23/12/2016 you should see the details by month but total wise will be:
- asOf 23/12/2016 (Input Date) - Result is Reservation dates 2017 with total revenue=1185
- Based on the above asOf date the previous year (thus 23/12/2015) - Result is Reservation Dates 2016 with Revenue = 650
Thank you in advance.
