Populate a GANNT chart with timelines extracted from date ranges

[abartozzi]

Hi Community, 

I'm trying to solve this one but i'm quite lost. I have this simulated dataset

Product name	Product Code	Start Date	Operation day	Duration	End Date	Departing Point	Arrival Point
TEST01	TEST01	04/01/2021	Moday	3 days	01/02/2021	Point A	Point B
TEST02	TEST02	01/02/2021	Tuesday	7days	10/06/2021	Point A	Point B

So, I have to populate this gannt chart where all the product are displayed according to start and end dates starting in the operation days and duration. 

E.g. for TEST 01 i should have  in the GANNT chart 4 lines starting on 04/01/2020 for 3 days, 11/01/2020 for 3 days, 18/01/2020 for 3 days, 25/01/2021 for 3 days and 01/02/2021 for 3 days.  

I am able to do so according to start and end date but it would create a long line for the whole period, but i failed to restrict it according to operation days. 

Please help mee🤣

thank you 

Albe

[Anonymous · Accepted solution]

@abartozzi 
You cannot have have a duration with text type, try change the column into Duration(days) with value 3 and 7 in whole number data type. 

Then remove the enddate and add the new duration column.

PaulZhengg _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.