7 Replies Latest reply on Jun 6, 2016 3:27 PM by Alexander Mou

    How to make a line chart using start date and due date?

    Tracey Dong

      For my case, there is no specific date in dimension against the metrics(Estimated Hours). I need to make a line chart (similar as below chart) shows how many total estimated hours each month for all IDs. For each ID, estimated hours per month is calculated by [Estimated Hours]/DATEDIFF('month',[Start Date],[Due Date]). But I have no idea how to create a date dimension as the month, and how to distribute the estimated hours to each month. Please help!

      Capture.PNG

       

      Data source is attached.

       

      Thank you very much!