question Need to create report where incident are created on saturday in Platform Analytics forum

Need to create report where incident are created on saturday

ManishKumaJ — Mon, 21 Oct 2024 15:57:39 GMT

I have created a report to show the incident created on Saturday for this month. I am getting correct count if I use score type, But I need a bar chart group by incident .
For example for this month saturday is on 5 oct, 12 oct, 19 oct so far, so it show these three values on the bar instead it is showing week, 2 week..etc. How can we achieve this

Re: Need to create report where incident are created on saturday

MizukiNakanish — Tue, 22 Oct 2024 00:42:07 GMT

Hi ManishKumaJ ,

Please try the following steps to see if you can do it.

1. Modify the Grouping Field

In your report settings, ensure that you are grouping the incidents by the "Created On" field and specify the aggregation to be done by "Day" instead of "Week."
2. Use a Filter

Set a filter in your report to only include incidents created on Saturdays. You can do this by using a "Day of the week" condition on the "Created On" field and selecting "Saturday."

3. Configure the X-axis
Ensure that the X-axis is set to display dates in "Day" format rather than weeks. This will give you individual bars for the specific Saturdays (like 5 Oct, 12 Oct, and 19 Oct).

Re: Need to create report where incident are created on saturday

Tai Vu — Tue, 22 Oct 2024 04:31:56 GMT

Hi @ManishKumaJ

Let’s give my approach a try to create a report that shows incidents created specifically on Saturdays. (specific day of week).

1. Create a report of type Trend.

2. Set query as following:

Opened (Created) trend on Saturday
Opened (Created) on this month

Sample:

3. Configure the report as following:

Trend by Opened (Created)
Calendar: Standard calendar
Per: Date

Here’s my result for April 2024.

If you prefer to display the report with weeks under the chart legend, just change the calendar to Gregorian calendar.

Let me know if it works for you.!

Cheers,

Tai Vu

Re: Need to create report where incident are created on saturday

Harish Bainsla — Tue, 22 Oct 2024 04:32:49 GMT

Hi @ManishKumaJ just use filter condition shown below

Re: Need to create report where incident are created on saturday

AndersBGS — Tue, 22 Oct 2024 06:03:24 GMT

Hi @ManishKumaJ ,

First of all, created a bar time series widget and set the per as to "week":

Next, create the condition for incidents only created on Saturday:

If my answer has helped with your question, please mark my answer as accepted solution and give a thumb up.

Best regards

Anders