Submitted and completed in one matrix

Hi,

I have a table of tickets with submited, completed, closed, etc. dates and other various info. I do understand how to separate them in two different visuals (like below):

So this will show submitted tickets by month (on the left) and completed tickets by month (on the right). Submitted has SubmitDate axis; completed has LastCompleteDate axis. So, different timestamps. This is made to show completed per month no matter when they were submitted.

What I do want to have is a matrix (well, basically something, but one visual) where will be tickets Submitted VS. Completed and ratio, split by month.

(just example, this one counts open vs completed)

What I am struggling is:

I took June submitted. It will show 72 Completed (with 54 highlighted in June), AND matrix will show 81 submitted, 78 completed, 3 open. From 78 Completed there are 54 that are completed in June and 25 completed in other months starting July (because of those submitted, which were closed after) + 3 still open.

From one point this is correct in flames of visuals, but what I want to achieve is: (example)

Submitted in *Month* = 50 (submitted after June 1st and before June 30th including)

Completed in *Month* = 60 (submitted anytime, but completed after June 1st and before June 30th including)

in one matrix. With ratio :)

I assume that there is something to deal with dates. Like I said, for these two visuals I do have 2 different date tables (submitted and lastcompleted). Perhaps I need a calendar, which is somehow linked to both date tables or something.

Hopefully someone will understand, as i spent so much time figuring out why stats are so awfully bad and got myself confused already. :)
Thanks in advance.