4 Replies Latest reply on Mar 21, 2018 4:25 AM by varun.kalra.2

# Best way to visualise dates on two axes?

Hi

I am trying to visualise number of hotel reservations for that were booked in a certain month for a certain checkin date in the future. My imagination draws me to build a box plot but am not very sure if this is the best way to show the relation between check in and booking date. For a box plot I have to create a calculated field which is a difference of days in check in and booking date but it still does not very clearly depicts how many booked in Jan 17 for July 17 for eg.

I have attached a packaged workbook wherein I have added a box plot and a simple bar chart. Please guide me if it can been done in a better manner.

Regards

Veekay

• ###### 1. Re: Best way to visualise dates on two axes?

Hi Veekay,

You could try measuring the count of booking ids against Month of Check in and place booking date on colors to define distribution.

It's a little messy but you could clean it up by creating a months ago field.

IF DATEDIFF('month',[Booking Date],[Check In Date]) < 5 THEN STR(DATEDIFF('month',[Booking Date],[Check In Date]))

ELSE '5+' END

Regards,

Ivan

1 of 1 people found this helpful
• ###### 2. Re: Best way to visualise dates on two axes?

Thanks Ivan,

I think what you ve done is a much better idea by grouping months together and use it as "N' months ago.

Is there a possibly a way to work out a scatter plot where in I can work out bookings in one month (for eg jan) and checkins scattered over the year ( Jan - Dec) . I tried but can t work out a scatter plot (attached)

Regards

• ###### 3. Re: Best way to visualise dates on two axes?

I don't think you want both dates on the axis.  You can filter on booking date and plot against checkin month like the screen below.

Regards,

Ivan

• ###### 4. Re: Best way to visualise dates on two axes?

Thanks Ivan,

I will go with the bar chart that has months ago field

Regards

Varun