0 Replies Latest reply: Oct 26, 2015 5:24 AM by Nelson Lam RSS

    Gantt chart help with quarter date axis conversion

    Nelson Lam

      Dear all fellow QV peers,

       

      I wish to convert my date axis in my grantt chart from MMM-YY to quarter naming convention. (Q1-2016, Q2-2016 etc...)

       

      Under normal circumstance, this can done in scripting level if date is used as one-dimensional. However, aggregation is used to for calculate duration which makes the situation alittle complicated.

       

      I have tried to use the following solutions but had failed to achieve any results:

      1. Define the following in script level but was unable to perform aggregation

      'Q' & Ceil(Month(Start)/3) as QUARTER_START,

      'Q' & Ceil(Month(End)/3) as QUARTER_END

      2. Change date format pattern in 'number' tab

       

      gantt  chart.jpg

      Thanks in advance,

      Nelson