Tabular report showing resolved incidents per week by assigned to

[D N]

How do I make a similar tabular report that shows resolved incidents over the last 3 months per week by assigned to? Attached is an example of what I'm looking for. It doesnt have to be exactly the same.

[AndersBGS]

Hi @D N ,

You can't - Also think about how long the report will be if you have 90 columns and maybe several 100 rows based on assigned to. Instead, your only option is to do it in Excel sheet or similar. 

if my answer has helped with your question, please mark my answer as accepted solution and give a thumb up.

Best regards

Anders

[D N]

Hi thanks for your response. I dont think it would ever be 90 columns. If the data captures the last 3 months, it would be roughly ~12 columns since 3 months averages out to be 12 weeks.

[Mark Manders]

The system doesn't register just dates of resolving, so you can't get this information in this way.

Question is: why do you need this export? You can just create a bar chart that shows you the numbers, what is the need of exporting this in a table? 

[D N]

Hi thanks for your response. The incident table has a field for closed and resolved which are date/time fields. The reason I was asking for a table format instead of a bar chart is because that is part of my requirements. 
They dont need this data exported. They want the dashboard visualization to be in table format when they view it on the dashboard.