clustered column chart with two pillar sets

Hi Guys,

I would like to plot the inflow and outflow of my data in one visual. For this I am using the clustered column chart. So I have one column with the ticket ID, one column with its creation date and one column, if its close, with its resolution date. My issue is, that the filtering of the visual seems to take place in the x-axis. But I cannot add more than one x- axis. So if I add my created column in the value field and also my resolved column in my value field, the x axis is deciding how the data is grouped. By this I get every two pillars looking the same. But I want to distinguish them so I see how many tickets have been created and how many tickets have been closed per month. 

Ah one important information, the data is all in one table, but if I use more than one table I get two different pillar set, with one right one and one constant one. So this doesnt seem like the way to go.

I really appreciate your support.

Best wishes and thanks in advance,

point