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

Community Alums
Not applicable

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

2 REPLIES 2

DJL2
Kilo Guru

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

manibaig
Mega Guru

can we use script include?