This content has been marked as final. Show 3 replies
I am looking to create a chart that shows numbers of open orders by date.
I have 3 fields for each order - order open date, order closed date and a counter. I can produce a chart that shows the numbers of orders increasing, by setting the x axis to Order Open Date. and the y axis as count(Counter) with Full Accumulation.
I would like to incorporate the Order Closed Date so that the line chart goes down as well as up, during quieter and busier periods.
Any suggestions would be welcome.