Need to create report and group it by week with starting day as Monday

Community Alums
Not applicable

‎09-03-2020 06:19 AM

Hi,

Need to create a report of high and critical incidents and group it by weekly basis with week start day as Monday. This week start day should be applicable for this report alone, we have global setting for week start day as from Sunday.

So report is going to fetch incidents which are high and critical created from Monday to Sunday in a week and group it by that week by mentioning dates e.g :-24-Aug-2020 to 30-Aug-2020.

Requesting help on the same.

Thanks

0 Helpfuls
  • 2,257 Views
2 REPLIES 2

DJL2
Kilo Guru

‎09-03-2020 09:28 AM

Hi Vineeth,

If you're not able to change the Global setting, you're not going to get this report, as the platform will aggregate by week in accordance to the parameter which has been set.

What you could do, is create a report with a relative time range and schedule this to run each Monday.  So, steps would be:

  1. Incident report, filtered for High and Critical
  2. Opened_relative_after_7_Days_ago
  3. Schedule to run 00:00 each Monday

This will return segmented data for the 7 days immediately prior to the day/time the report is run.

An alternative, is to extract your data from the platform and post-process in Excel, grouping the data by 7 day intervals from a predefined start point.

Thanks,

DJL

0 Helpfuls

manibaig
Mega Guru

‎10-17-2022 05:18 PM

can we use script include?

0 Helpfuls