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
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).
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
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
