I have been asked to produce a report which will show both the total amount of In Progress incidents (not at the resolved or closed status) against the total amount of newly created incidents by week over a 3 month period. Im looking to produce this within Crystal if this is possible? and how to go about creating the report?
I can create a graph to show new Incidents per a week but im stuggling to find out how to show how many incidents were In Progres for that week, Ive attached a mockup of how i would expect the report to roughly look. Any assistance would greatly be appreciated.