1. 

   Peter Schober, Member

   Hello @all,

   I have problems to generate a Gantt diagramm I would like to have. I have the following select statement to get data:

   select label, start, end, stage from project_data;

   Resultset:
   label start end stage
   project: 47921 22.04.2013 00:00:00 23.04.2013 00:00:00 Datenlieferung
   project: 47921 22.04.2013 00:00:00 23.04.2013 00:00:00 Druckfreigabe
   project: 47921 25.04.2013 00:00:00 26.04.2013 00:00:00 Auslieferung (eintreffend)
   project: 47927 29.04.2013 00:00:00 30.04.2013 00:00:00 Datenlieferung
   project: 47927 30.05.2013 00:00:00 31.05.2013 00:00:00 Druckfreigabe
   project: 47927 13.05.2013 00:00:00 14.05.2013 00:00:00 Auslieferung (eintreffend)
   project: 49239 21.05.2013 00:00:00 22.05.2013 00:00:00 Datenlieferung
   project: 49239 22.05.2013 00:00:00 23.05.2013 00:00:00 Druckfreigabe
   project: 49239 05.07.2013 12:21:05 Auslieferung (eintreffend)

   Currently the Gantt diagramm is generating multiple line per label (dependning on the number of different stages). Is there any opportunity to have all stages per label in one line?

   Thanks in advanve for your help.

   Peter
2. 

   myDBR Team, Key Master

   We've added a new gantt-chart option 'gantt.single_label' which allows multiple stages at single label. Run the updater to get the latest build and add the option in the report:

   select 'dbr.chart.options', 'gantt.single_label', 1;

   --
   myDBR Team
3. 

   Peter Schober, Member

   Hello myDBR team,

   I have currently myDBR 3.9.2 (build 2050) installed and it does not work. Which is the version with the new option?

   Thanks in advance for your help.

   Peter
4. 

   myDBR Team, Key Master

   Peter,
   If you run the updater, you will get the latest version that includes the option.

   The current version is 3.9.3 build 2072.
   --
   myDBR Team
5. 

   Peter Schober, Member

   Hello team,

   it works now. But I have another question regarding baselines. Is it possible to have a individual baseline for each single stage (instead of having on for the label)?

   Thanks in advance for your answer.

   Peter
6. 

   myDBR Team, Key Master

   Do you mean when the 'gantt.single_label' option is not set? We can take a look at it.

   --
   myDBR Team
7. 

   myDBR Team, Key Master

   This is now possible in the latest build. The gantt.baseline has now an optional stage parameter which can be set.

   The following will put the baseline to the first 'Label' label:

   select 'dbr.chart.options','gantt.baseline', 'Label', '2013-01-06', '2013-01-14';

   And with the new option, the baseline will put to the first 'Label' which has 'Stage' stage:

   select 'dbr.chart.options','gantt.baseline', 'Label', 'Stage', '2013-01-06', '2013-01-14';

   --
   myDBR Team
8. 

   Peter Schober, Member

   hello team,

   thansk a lot. We are updating the version today and I'll test it tomorrow. I'll keep you informed.

   Thanks again.

   Peter
9. 

   duane, Member

   I'll piggy back on this as it is related :-)

   I've got a gantt chart with 'stages' and the legend, but the category_order chart option doesn't seem to work to order them.
   

   select 'dbr.chart.options', 'category_order', '1', '2', '3', '4'; 

   
   (I'm using numbers for stages in this case)

   Is there another way to do it with gantt charts or doesn't stage (category) ordering work?
10. 

    myDBR Team, Key Master

    Duane,
    we've added support for category_order to the Gantt-charts, so you can set the legend order to your liking.

    Additionally, we've enhanced the legend positioning with support of legend.position and styling of the legend with legend.style.

    See example of this in the demo.

    Default values for both legend.position and legend.style can be overridden from defaults.php so you can set your own preferred formatting.

    --
    myDBR Team
11. 

    duane, Member

    Excellent - it all works fine! I'm always amazed by how fast you respond and implement new features (and fix bugs). Well done!

    One added suggestion: for 'category_order' you could add a 'ascending' or 'descending' sort option to auto- order the category listing on that basis. For instance if I have numeric values like '1, 2, 3, 4' and I know the range it is easy. But when I have '1, 3, 4, 10' and new values could be inserted or appended to this list, when I put the full range (1,2,3,4,5,6,7,8,9,10,11) it displays all those as categories in the legend despite the fact they aren't all in the 'set'.
12. 

    myDBR Team, Key Master

    Do you mean that the category order could be defined as asc / desc (aphabetical/numeric) without actually defining the values itself?

    --
    myDBR Team
13. 

    duane, Member

    Yes - asc / desc (aphabetical/numeric) without defining the actual values (which are dynamic and in some cases constantly chancing).

    For simple circumstances I can do this with ordering the query and it has the save effect, but in multi-value queries (e.g. gantt chart), sorting the query by multiple columns doesn't always result in the category order being sorted asc/desc.

    (at least in my situation).

Reply

You must log in to post.