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

[sthi]

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 a its own dimension (like it is my Start Date), and is forcing me to aggregate the field.

Further, it seems like no matter which aggregation method I choose, the end date in the visualization is alwas +1 day from the start date.

I've tried instead to calculate the duration and use that field instead, but the exact same thing happens. 

[VahidDM]

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]

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_Start	Transaction_End	Resource	Job	Operation ID
8/18/2021 13:10	8/18/2021 16:01	A	JOB1-01B	JOB1-01B-2
8/19/2021 6:27	8/19/2021 8:22	A	JOB1-01B	JOB1-01B-2
8/19/2021 12:40	8/19/2021 16:37	A	JOB1-01B	JOB1-01B-2
8/19/2021 2:28	8/19/2021 2:30	B	JOB2-09A	JOB2-09A-0
8/19/2021 2:25	8/19/2021 2:25	B	JOB2-09B	JOB2-09B-0
8/20/2021 6:25	8/20/2021 8:41	A	JOB2-09B	JOB2-09B-1
8/16/2021 6:30	8/16/2021 17:59	C	JOB3-01	JOB3-01-4
8/17/2021 6:03	8/17/2021 10:39	C	JOB3-01	JOB3-01-4
8/16/2021 13:48	8/16/2021 18:00	D	JOB3-01	JOB3-01-5
8/16/2021 20:00	8/17/2021 2:42	E	JOB3-01	JOB3-01-5
8/17/2021 5:58	8/17/2021 9:06	D	JOB3-01	JOB3-01-5
8/17/2021 10:40	8/17/2021 13:35	C	JOB3-01	JOB3-01-5
8/16/2021 6:02	8/16/2021 10:25	F	JOB3-01	JOB3-01-6
8/17/2021 9:07	8/17/2021 10:33	D	JOB3-01	JOB3-01-6
8/17/2021 14:40	8/17/2021 18:13	F	JOB3-01	JOB3-01-6
8/17/2021 18:06	8/18/2021 2:29	G	JOB3-01	JOB3-01-6
8/18/2021 5:57	8/18/2021 17:01	F	JOB3-01	JOB3-01-6
8/18/2021 15:54	8/18/2021 16:46	D	JOB3-01	JOB3-01-6
8/19/2021 7:41	8/19/2021 4:41	E	JOB3-01	JOB3-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 · Accepted solution]

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  !!