Hello, I created a Gantt chart that displays different events depending on the time as you can see below (I put my project as an attachment, you will have to look at the screen "Screen2") :
All my events are stored in a SharePoint list called "Provider2".
Usine : Text type
DateArrivee : Date and Hour type
DateFin : Date and Hour type
Status : Choice type
I would like to add to the left of my diagram, a calendar so that when you click on a date, it displays the diagram with all the events corresponding to this date. But I can't seem to realize that at all.
I would like to have something like this :
Can you help me please ? Thanks in advance ! I've been stuck on it for several days 😞
--------------------------
In red, it's my gallery which contains all the hours.
In blue, it's my gallery which contains all my items.
In fushia, it's my gallery that displays all the columns for the hours.
lblIndicator_1 :
Fill : If(
ThisItem.Status.Value="Not Started";
White;
ThisItem.Status.Value="Active";
Orange;
ThisItem.Status.Value="Delayed";
Red;
ThisItem.Status.Value="Completed";
Green;
Gray
)
X : Value(
DateDiff(
Date(
Year(ThisItem.DateFin);
Month(ThisItem.DateFin);
Day(ThisItem.DateFin)
);
ThisItem.DateFin; Hours
)
)* (galBodyMonths_1.Width / 24)
Width : (Value(
DateDiff(
Date(
Year(ThisItem.DateFin);
Month(ThisItem.DateFin);
Day(ThisItem.DateFin)
);
(ThisItem.DateFin); Hours
)
) -
Value(
DateDiff(
Date(
Year(ThisItem.DateArrivee);
Month(ThisItem.DateArrivee);
Day(ThisItem.DateArrivee)
);
ThisItem.DateArrivee; Hours
)
)
) +1 * (galBodyMonths_1.Width / 24)
