Hi,
I have a qvw that has two datasets each with its own unique calendar.
I have [arrivals_dataset] with an a[rrivals_master_calendar] and a [departures_dataset] with a [departures_master_calendar].
Within the arrivals_dataset I have :
Guest_ID (Key)
Arrival_ID (Key)
Arrival_Date
and other fields
Within the departures_dataset I have :
Guest_ID (Key)
Departure_ID (Key)
Departure_Date
and other fields
Is there any way to create a simple bar chart with a neutral 'Month Year' along the x-axis and show, per month, the total arrivals and total departures. We are trying to capture peak times as we can see that duration of stays vary wildly! I could achieve this in two separate charts based on each independent calendar - but it would be great if we could combine the two.
Any help appreciated!
Phil
