11 Replies Latest reply on Jan 3, 2014 8:13 AM by Matt Lutton

    Problem getting  the correct data

    Pankaj Chopra

      I have Hours Booked as a measure from my data for certain weeks upto 1st week of April as you can see between Booking Start Date and End Date. I also need to calculate Hours Available for those particular weeks but since there are only entries in the database where there is a booking ( like for eg for some days there is no booking so no data) , so the Hours Available calculation comes out wrong when I am trying to find Hours Available by week. Also when I aggregate it by Name or Geo it comes out wrong. How can I correct this?

       

      Also I need to fill Hours Booked as 0 in weeks when I have no entries at all and Hours Available as 40. How to do that as well?

       

      Please help. Thanks