Hello, I have the need to create a bar chart where the x-axis is the months of the year, the y-axis corresponds to events that happen in those months, what I don't do is the following:
There's a start date for a problem for example June, and it has a possible fix date in October and it was finally fixed in December (in that same year), so the chart would show a bar in the month of June (when the problem started and was recorded), a bar for each month in which it wasn't fixed, In this case, a July, August, September, October, November, and even December bar would appear. How can I make this calculation? How did that measure create that if the settlement date is not the same as the estimated date, it will be displayed in those months until the settlement date is met?
