Forum Discussion

sthi's avatar
sthi
Frequent Visitor
5 years ago
Solved

Gantt 2.2.3 End Date Issues - forcing aggregation instead of individual attribute

I'm trying to setup visualization using Gantt 2.2.3, but I'm running into issues setting up the proper End Date. My End Dates column is for sure in datetime format, but it's not letting me use it as ...
Need Help
  • VahidDM's avatar
    VahidDM
    5 years ago

    Hi sthi 

     

    Due to the sample table you shared here, it seems all of your tasks' duration is less than a day.

     

     

    BTW, you can use your data to create a Gantt chart like this [set the timeline to Day or Hour]:

     

    You can not split your activity!

     

    Please download this PBI file with a gantt chart based on your sample data:

    https://gofile.io/d/3AwFqe

     

     

    Did I answer your question? Mark my post as a solution!

    Appreciate your Kudos  !!

VahidDM's avatar
VahidDM
Icon for Super User rankSuper User
5 years ago

Hi sthi 

 

What is that Job you added as a Parrent? is that a WBS?

You need to set the finish date as Latest.

I Created a sample data in excel as below and use that in the Gantt chart; it works well.

 

Can you send the sample of your data as a table here?

 

Did I answer your question? Mark my post as a solution!

Appreciate your Kudos  !!

  • sthi's avatar
    sthi
    Frequent Visitor
    5 years ago

    Hello VahidDM ,

     

    Yes, the Job can be thought of as the parent WBS tasks, with smaller sub-items as Operation IDs.

     

    Here is the sample of my table:

    Adjusted_StartTransaction_EndResourceJobOperation ID
    8/18/2021 13:108/18/2021 16:01AJOB1-01BJOB1-01B-2
    8/19/2021 6:278/19/2021 8:22AJOB1-01BJOB1-01B-2
    8/19/2021 12:408/19/2021 16:37AJOB1-01BJOB1-01B-2
    8/19/2021 2:288/19/2021 2:30BJOB2-09AJOB2-09A-0
    8/19/2021 2:258/19/2021 2:25BJOB2-09BJOB2-09B-0
    8/20/2021 6:258/20/2021 8:41AJOB2-09BJOB2-09B-1
    8/16/2021 6:308/16/2021 17:59CJOB3-01JOB3-01-4
    8/17/2021 6:038/17/2021 10:39CJOB3-01JOB3-01-4
    8/16/2021 13:488/16/2021 18:00DJOB3-01JOB3-01-5
    8/16/2021 20:008/17/2021 2:42EJOB3-01JOB3-01-5
    8/17/2021 5:588/17/2021 9:06DJOB3-01JOB3-01-5
    8/17/2021 10:408/17/2021 13:35CJOB3-01JOB3-01-5
    8/16/2021 6:028/16/2021 10:25FJOB3-01JOB3-01-6
    8/17/2021 9:078/17/2021 10:33DJOB3-01JOB3-01-6
    8/17/2021 14:408/17/2021 18:13FJOB3-01JOB3-01-6
    8/17/2021 18:068/18/2021 2:29GJOB3-01JOB3-01-6
    8/18/2021 5:578/18/2021 17:01FJOB3-01JOB3-01-6
    8/18/2021 15:548/18/2021 16:46DJOB3-01JOB3-01-6
    8/19/2021 7:418/19/2021 4:41EJOB3-01JOB3-01-7

     

    And this is more or less what I'm trying to get the graph to look like: 

     

     

    I'd like to have multiple segments, so that I can see the utilization times of my resources and the times spent on each job/operation.

     

    Thank you

     

    • VahidDM's avatar
      VahidDM
      Icon for Super User rankSuper User
      5 years ago

      Hi sthi 

       

      Due to the sample table you shared here, it seems all of your tasks' duration is less than a day.

       

       

      BTW, you can use your data to create a Gantt chart like this [set the timeline to Day or Hour]:

       

      You can not split your activity!

       

      Please download this PBI file with a gantt chart based on your sample data:

      https://gofile.io/d/3AwFqe

       

       

      Did I answer your question? Mark my post as a solution!

      Appreciate your Kudos  !!