Need a report to show number of tickets created each week for the past 4 weeks.

[jacobpeppers]

I'm trying to create a bar report to show how many tickets were created each week for the past 4 weeks.  So it would look like this:

Bar 1 - [4 Weeks ago - 100 tickets created]

Bar 2 - [3 Weeks ago - 90 tickets created]

Bar 3 - [2 weeks ago - 110 tickets created]

Bar 4 - [1 week ago - 150 tickets created]

I am able to get something similar by making a simple bar report, but the ranges are using the default (Same Day, 2 Days, 2–5 Days, 5–7 Days, 1–2 Weeks, 2–4 Weeks, 1–2 Months, > 2 Months) which doesn't really break down the data how I need (1 week, 2 week, 3 week, 4 week).

I created custom ranges which does seem to work, however, doing this changes the range for any user who is currently using that field on one of their reports, so that would be a no-go in our organization.

Is there a way to create this report, or any way to create custom ranges for 1 report without effecting other reports using the existing range?

Thank you!

[Ivan Betev · Accepted solution]

Hi jacobpeppers,

the only thing that comes into my mind is to use Type column and aggregate per Week, but what you will see will be the data on the first day of the week.

I hope it helps.

Have a nice one! 🙂