Hi,
I am trying to make a chart that shows how many orders were opened and how many were closed per month on the same chart. Orders that have been opened and closed should show twice on the chart. Once in the month they opened & once in the month they closed.
The dataset looks like this, where the open and closed dates exist on the same row. What can I use for the X axis that will have both fields accurately applied per month? If I choose one, then the other date is incorrect. A beastmode of the 2 does not work either.
Any help is greatly appreciated. :)