I need help
I'm making this gantt chart via 'recipe of gantt chart', but its pretty messed up. I've these tables;
-Functional Requirement Done
-Business requirement Blah Blah
[whether it has been gone live, or dropped or Deployed]
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.