Stacked column based on historic data

[mathias1998]

Hi, 

I have the following chart built: 

I would however like to add stacked columns within it, where each layer in the stacked column should correspond with the status of the ID (i.e., 0-Not Started, 1-Deliverable Defined, 2-Draft, 3-Draft in Review, 4-Approved) for any given date. 

In other words, an ID may have the status 0-Not Started on October 11, but this might change to 4-Approved on October 12 (I am importing data from SharePoint). Hence, the stacked columns should correspond to what was the status distribution per date, and prefferably only show columns up until TODAY. 

I have the following table: 

Have any of you touched upon this, or have any tips on how I could proceed? 

[v-henryk-mstf]

Hi @mathias1998 ,

I don't seem to quite understand what you are looking for, can you provide screenshots of the desired results and describe them, as well as some test data. I will get an answer for you as soon as possible.

Best Regards,
Henry