4 Replies Latest reply: Jun 17, 2013 8:11 AM by Yannick Durand RSS

    Automatic scale for bar chart with several expressions

    Yannick Durand

      Hi,

      I am trying to do a gant-like chart.

       

      My data are like this :

       

       

       

       

      PROJECTPROJECT_TYPE
      START_DATE_TYPE_1END_DATE_TYPE_1START_DATE_TYPE_2END_DATE_TYPE_2

      A

      101/01/201201/02/2012
      A2

      01/03/201201/04/2012
      B101/03/201215/05/2012

      B2

      18/02/201210/03/2012












       

      If I try to do a bar chart :

      dimension PROJET&PROJECT_TYPE

      expression sum( if( PROJECT_TYPE = 1, END_DATE_TYPE_1 - START_DATE_TYPE_1 ))

      with an offset sum( if( PROJECT_TYPE = 1, START_DATE_TYPE_1 ))

      unchecking forced0

      IT IS OK

       

      Idem if I do the same for TYPE2

       

      BUT if I have 2 expressions (one for type 2 and one for type 1) then the min value of the scale is 01/01/1900 and max value is 01/01/2020

       

      Does someone know why ?

       

      Thanks a lot

       

      I attach a doc.