1 Reply Latest reply: Mar 16, 2016 11:16 AM by Chaitanya Pericherla RSS

    Gantt chart query

      Hi guys


      I need help


      I'm making this gantt chart via 'recipe of gantt chart', but its pretty messed up. I've these tables;

      • Project Names
      • Project Codes
      • Start Date
      • End Date
      • Milestones

                  It involves;
                     -Requirement Phase

                      -Functional Requirement Done
                      -Business requirement Blah Blah

      • Milestone dates
      • Project Status

                [whether it has been gone live, or dropped or Deployed]

      •      Calender

      So this is what I'm getting now


      Though its a half screenshot. the expression i used was; max(End Date)-Min(Start Date) and i know this should not be not be the expression but the funniest part is i cant come up with a new expression.

      All i want is something like that


      The brown color representing that its first milestone has been completed yellow represents the second one, and the red represents the fourth milestone and if it gets go live then it gets all green. This all would be changing colors as per dates. idk how to achieve that but i want to achieve it.