Is it possible to report on relative # of weeks?

[SusanWinKY]

We've been asked to add a condition to allow users to filter a report based on a relative # of weeks.   For example, report on all incidents created during the previous 4 weeks (not including the current week).   They want it to behave similar to the relative conditions for, say, the last 30 minutes or last 2 months or last 10 days.   Is this possible, and if so, how can we accomplish it?

[folusho]

Hi Susan,

Alternatively, you can convert the weeks to days and add it to your filter condition. This is exactly what I used for my report: I wanted to report for 4 weeks.

Hope this helps.

Regards.

[SusanWinKY]

Folusho, this is what I initially proposed but then the requester explained that he needs the last four full weeks. Similar to how the 1 month ago condition would give me September's records if I run the report in October, he wants the last four full weeks prior to the current week.  Make sense?

I figured out that I can use two JavaScript functions to get the start date and end date for that but I can't figure out how to concatenate them in a condition builder so that I can use them in a filtered list on a report.  

[folusho]

Hi Susan,

The closest you would get is something like this below: created at or before Last week (excludes current week) and relative to (on or before) last 30 or 35 days. I tried it in my instance and it worked. At the moment, it is not possible to customize the out of the box options in the filter condition. I hope this works for you.

Regards.