I have a Gantt Chart which i have calculation field to give my dates DATEDIFF("day", end_date, start_date), my view is by semester, I would like to sort my projects ascending how I could do that ?
Attached some sample data.
It was expecting to have the pattern according the number in the file "Gantt"
@Lucas Zago ,@Lucas Zago
(sorry I could not figure out which was the real you)
"Hola" and hope all is well on your side as it's been a long time.
Here is a simple solution to your problem as shown below:
Also I noticed a typo in your formula as the correct formula for
Duration in a Gantt chart is
DATEDIFF("day", [start_date],[end_date])
I have attached the twbx file below. Let me know if you have any
questions. Hope this was helpful and correctly answered your
question. Take care, best wishes and "Bom Dia" 😁!
Sincerely,
Soumitra
