My Senior Manager is wanting a report that will show summarize which support team had an incident assigned to them at the end of that week at a given point in time.
I am thinking of have a parameter field to input the end date then asking how many weeks I want to go back.
So the report could show how many incidents each support team had open at the end of that week then I can the use this to plot it on a graph.
So it could look something like this.
Any help / advice would be great.