Submitted by d bartlett on 2020/12/31 16:41
Hi Pierre,
 
The Gantt Chart updates the Summary Task Bar Duration but not the Weeks Duration cell nor the Days Duration cell.   See pasted image below, where 'SCC-P3' Summary Task 'Wks' column is stuck on 8.70 and 'Days' on 61.   I've tried every setting-change and trick I can think of with no success, including refresh, closing/reopening the Grid, closing/reopening InfoQube, deleting/rebuilding the entry items, upgrading from 9.116.m to 9.117Pre1.
 
 
Gantt Bar color selection disconnect:  the color selection for individual bar color per 1st pasted image below (lavender chosen), vs setting the bar default color via grid settings per 2nd pasted image below - there is no correlation between the two methodologies for choosing color, the appearance is different, the displayed colors are different, there is no 'lavender' color to choose from via grid settings.   Furthermore, when I copy/paste the lavender numerical ID # from Item Properties into the Grid Bar Default Color box, the pasted # won't stick.   Ergo, although by right-clicking on a bar I chose lavender as that bar's color, I can't figure out how to make lavender the bar default color. 
 
 
 
thanks
Doug Bartlett

Comments

Hi Pierre,
 
Any fix-it thoughts re Gantt Chart updates the Summary Task Bar Duration but not the Weeks Duration cell nor the Days Duration cell?
 
thanks
Doug Bartlett

Pierre_Admin

2021/01/11 11:32

Permalink

Hi Doug,
 
Can you show show these 2 fields are calculated ? They aren't stock fields unless I'm mistaken...
(Field Properties > Equations)
 
Pierre_Admin
IQ Designer
 

d bartlett

2021/02/06 13:35

Permalink

Hi Pierre, sorry for taking so long to respond -
 
The "Days" field is the IQ "Task Duration" Field, I renamed it to "Days' because that's the unit of time it displays.
 
The "Wks" field is a new field I created in April 2019 with your help, because Weeks are more relevant to me than Days for Construction scheduling.   The Field Properties/Wks/Row Equation you provided was "=formatnumber( [TaskDuration] /7,1)".   "Wks" updated fine until sometime in late 2020, but now neither the "Wks" nor the "Days" columns update anymore.
 
BUT, I see Field Properties/Task Duration(Days)/Row Equation is blank, that seems odd to me - so maybe that's the issue, it needs a formula there?
 
Doug Bartlett

Hi Pierre,

I believe I resolved the issue with Summary Task row "Task Duration" field/cell not updating in Gantt Chart.

Manage Fields > Task Duration > Equations > Column Equation: Set first DropDown Menu Box to "Parents" and second to "SUM".   They both used to be blank, for whatever reason.

Task Duration field/cell in the Summary Task row seems to be updating fine now.   No unintended consequences that I've noticed so far.

take care, Doug

Good Morning Pierre,

Last night, while preparing for a presentation for which I intended to use the Gantt Chart feature, I discovered that in Day View the end of the Bar falls one day short of the TaskEnd Date.   See image below, where the tasks beginning with "P-1" all end on Fridays per the TaskEnd Date, but the Bar ends the day before on Thursday.   If I change TaskEnd Date to Saturday, then the Bar extends to Friday.   Related to that, Duration Weeks and Days isn't right, look at Macleod DR or Courtyard Door for instance where per TaskStart and TaskEnd input dates the timeframe should be 3.0 weeks and 15 days, but they're 2.0 and 14.

I investigated the various Gantt Chart settings but couldn't see any obvious issues or fixes.   I hid non-working days (weekends) but that didn't help.

Hoping you might have some ideas.

Gant Bars Fall One Day Short

thanks, Doug

 

Hi Doug,

Currently, unless a time is specified, all dates refer to hour 0, meaning midnight, so a task starting on April 1st starts at 2021-04-01 0h00 and if it ends on April 20th, it ends on 2021-04-20 0h00 too. It of course appears to end on the 19th...

Suggestions ?

Pierre_Admin

Morning Pierre,

For me, as a construction project manager, if I've got a project task starting on a Monday and ending on a Friday, that means 5 working days including the entirety of the Friday, which is how I need the Gantt Bar to illustrate the task timeline.

What if TaskEnd was recalibrated to the 59th minute of the 23rd hour of the end date.    I'm not a programmer guy, but I think that would then include the entirety of the end day.

What I don't know is if that recalibration would cause other unintended consequences inside InfoQube.

thanks

Doug

Hi Pierre,

Is there an equation I can enter into a field setting somewhere, somewhere in TaskEnd for instance, that would make the adjustment so that the Gantt Bar would fill to the end of the TaskEnd day instead of only to the beginning?   Without there being unintended consequences elsewhere in InfoQube.

thanks, Doug

Hi Doug,

I've been thinking about your problem. It seems that there are 2 large groups of applications that can use Gantt charts (if someone thinks of another, please chip in). Consider an item that starts on Jan 1 and ends on Jan 2:

  1. Task management: In this case the task is 2 days long
  2. Hotel reservations: In this case the stay is 1 night

We must find a way to reconcile these two in the most elegant way (i.e. without having to enter start/end times)

Any thoughts ?

 

Hi Pierre,

Excellent examples of the two different perspectives, I understand better your dilemma now.

Ability to toggle end date between start-of-day or end-of-day sounds like real reasonable solution.

Staying Tuned with great anticipation!

thanks

Doug

 

Hi Pierre, new Gantt Chart Question - in a Gantt Chart Grid, is it possible to hide a row(s), similar to hiding a row(s) in Excel?

For instance, in the Gantt Chart below, I'd like to make it public but hide the two rows "Gord Gone", because it's internal tracking info, not for the public.

(also, how do I resize the picture below after inserting it, it only needs to be half as wide but I'm not finding a way to reduce it dimensionally after inserting it?   I did reduce the file size by half and then reinserted it, but the width didn't reduce)

thanks, Doug

Gantt Chart Hide Rows

Hi Doug,

  1. You can add a "HideThisTask" column and use column filter to hide these. Alternatively, you could select the items to be shown and do a Hoist. If the main item is not shown, you can show 1 level of context parent
  2. This is an issue with the updated website. You need to switch to source view and add a width=50% parameter

Pierre_Admin