Two things first.
I know you turned down Schedule chart, but may I give you two sample images that showcase how it can be used to deliver pretty much the same information you had.
So the object is Schedule chart and the roles are as follows:
- Task: Components
- Start: Start Date i.e. calculated item using function DateFromMDY(10, 12, 2019)
- Finish: Date
- Lattice columns: Type
To get this done I had to restructure the data like this:
The chart on the right uses data aligned like this:
See how to use one filter for multiple data sources by mapping your data from SAS’ Alexandria McCall.
Find more tutorials on the SAS Users YouTube channel.