Add new "week" definitions?

RickFP22
Tera Contributor

‎11-14-2023 01:55 PM

In Reporting, we have "This Week", "Last Week", and "Next Week" options available.

SNOW_ThisLastNextWeek.png

 

Is there a way we would be able to add/create new custom "weeks" in addition to these options
(e.g. "2 Weeks Ago", "5 Weeks Ago", ">8 Weeks Ago", etc.)?

The desire is to have them work the same way as the other "week" options, keeping the dates as Mon-Sun. It would make reporting in my current environment much easier! Right now things are quite manual and having this option available would save me a lot of time and effort.

Any suggestions would be much appreciated; thanks ahead of time!

Labels:
0 Helpfuls
  • 365 Views
1 REPLY 1

Aylee Andersen
Kilo Sage

‎11-14-2023 04:09 PM

Hi @RickFP22,

 

You could try modifying the Global "Get Date Filter Options for Date Filters" Business Rule with your own custom queries. I believe that Business Rule is what affects the reporting (interactive) filters.

 

Hope that helps!

- Aylee

0 Helpfuls