How can I create in Tableau stacked column chart for three variables and discrete OX data?

Question

I am trying to create a stacked column chart in Tableau. But something is wrong and I just can't do it. There are some examples of my tries:

However, I can easily do it in excel:

That is a Link to the data: Data for the Chart

for creating on the OX axis year and week I converted them to the string format and them concatenated them.

How can I create in Tableau stacked column chart for three variables and discrete OX data?

Answer 1

Reshape your data so it looks like this:

You can use the Tableau Excel Add-on to reshape it or do it in Python given your data file name.

This way the New, Closed, Open are all in a single column and your Quantity can be summed in a single column (I renamed those columns to Type and Quantity)

Then you can create your desired result.