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

[Andreas_Hafner]

Hi Serhat,

[Andreas_Hafner]

Hi Serhat, thats an interesting task! Without knowing all the details, I would suggest you try it with a table. To create something that looks like your first picture, for the columns you could create restricted measures (dynamically restricted on a date dimension (you need an additional date/timestamp dimension to be able to compare it to the other dates)) for "gestern", "heute", "morgen", so that "heute" always looks at the current date and so on. Below the restricted measures the Dimension "Minutes". To create the colored lines for each order, you could try to set thresholds. For that you would have to adjust your data so you have values on each order, date and minute combination within the start and end dates. Or you can try to create a calculation for that (if date >= planned start date and date <= planned end date, then 1, else if ...) . For Order a write a 1 for each minute between start and end date. That would be your color grey if you create a threshold for values <=1. Same for the other colors, with different values between start and end dates. For the color green write value 2 (treshold >1 and <=2 ) and for red write value 3 (threshold >2). You would also have to change the threshold style to fill the background of the cell, in the styling panel of the table. I hope that helps! Contact me directly if you have further questions.