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

    Best way to visualise dates on two axes?

    varun.kalra.2

      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.

       

      Thanks in advance

       

      Regards

      Veekay