Gantt chart in SAC without custom widget for order scheduling/monitoring

[serhat_hrzl]

Hello dear community,

I have the following problem. We have the requirement to display an order monitoring dashboard in the SAC that resembles a Gantt chart. However, we are not allowed to use custom widgets. The final product must look like this:

As a first approach, I used several stacked column charts, the planned tasks in minutes as bars in gray, the actual tasks in red or green (red = If the time for the task is more than planned, green = If the time for the task is smaller than planned). However, I don't know how to show the time frame (5 days) in the charts. Another problem is that the minutes for the steps are not sorted according to them, which means that all minutes only for a order are sorted by color - which does not meet the requirements.

The structure of my data is like following:

Dimensions:

- Order

- StepID

- Planned Start Date (Timestamp)

- Planned End Date (Timestamp)

- Actual Start Date (Timestamp)

- Actual End Date (Timestamp)

- Flag Bar (gives a X or I if the actual time is more than the planned time for coloring of the bars)

Measures:

- Planned Minutes

- Actual Minutes

I look forward to your answers and thank you in advance.

SAP Analytics Cloud, analytics designer SAP Analytics Cloud