Issue in days calculation while plotting Gantt Chart

Sun, 21 Aug 2016 10:12:45 GMT

Hello Everyone,

I have an issue in calculating time taken for activities which is used in plotting a gannt chart.

In Qlik app, I am calculating activity wise (field - activity) time taken (fields - start_date, end_date). For this, I am subtracting activity wise max(end_date) - min(start_date).

But, there is an issue. Certain activities are repeated after certain time. So, the system is calculating time taken for an activity based on max and min date, which is wrong in few scenarios. For example. If an activity1 is done between 18-08-2016 and 25-08-2016, and activity2 is done between 25-8-2016 to 30-08-2016 and activity3 is done 30-8-16 - 2-9-16. Again activity1 is done from 02-9-16 to 8-9-16. In this scenario, for activity1, the system is calculating time taken as 21 days (18-8-16 to 08-9-16), while it should be ; 7 days+ 6 days = 13 days.

Please help me in calculating the time taken properly.

Thank You,

Rahul Krishan Goyal

Re: Issue in days calculation while plotting Gantt Chart

swuehl — Sun, 21 Aug 2016 13:44:45 GMT

Depending on the data, something like

=Sum(end_date) - Sum(start_date)

might return the correct total durations per activity.

topic Re: Issue in days calculation while plotting Gantt Chart in App Development

Issue in days calculation while plotting Gantt Chart

Re: Issue in days calculation while plotting Gantt Chart