Forum Discussion

DebbieK's avatar
DebbieK
Helper I
4 years ago

Iterating and comparing rows

I have a table of tasks assigned to different people, with set due dates, hours and priorities. I have previously processed these (in Visual Studio) to determine an order of works. This was done by ...
Need Help
danextian's avatar
danextian
Super User
4 years ago

Hi DebbieK ,

 

I am honestly confused with the sample and expected results provided. The due dates don't match as well as the priorities. For ID5, the dates are all 1/8 in the sample data but they're different in the expected result except for one. The priority numbers are also different - {900,500,100} vs {900,500,200} 

 

 

DebbieK's avatar
DebbieK
Helper I
4 years ago

Hi Danextian - thank you, and sorry for the mistake in the sample data, one of the due dates were wrong. I have now corrected this.

 

Note in the sample data it is sorted by due date, in the output data it is grouped by ID and then sorted by rank. 

  • danextian's avatar
    danextian
    Super User
    4 years ago

    Hello,

    Where can I find the hours?

    Determining projected completion dates, based on the sum of the hours of tasks ranked above them

     

    Also, how is the projected end date computed? I am assuming that it is 7 (x rank-1) days from rank1 project.

    • DebbieK's avatar
      DebbieK
      Helper I
      4 years ago

      Hi danextian - thanks for your help. 

       

      The hours = 8 hours x number of working days. 

       

      The projected completion date is the end of the previously ranked project + working days. For example ID 5, top ranked project finishes on 15/08/22. ID 5 second ranked project then has a completion date of 15/8/22 + 5 working days being 22/8/22 (due to weekend days). 

      • danextian's avatar
        danextian
        Super User
        4 years ago

        I am confused how the rank is calculated. For ID5, it appears that they're ranked by priority. For 7, they are ranked by Due Date.