Reports
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-01-2024 02:33 PM
I need to create a report to show the incidents and requests created by new hires during their first 30 days of employment.
How can I configure the data range conditions?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-01-2024 08:31 PM
Hi @RodolfoT
1. Navigate to Reports:
- Go to Report. Create New.
2. Choose Report Source:
- Choose the source table (you may need to create separate reports for incident and sc_request).
3. Set the Report Conditions:
- Add conditions to filter incidents/requests created by new hires.
Example for Incident Table
- Table: incident
- Conditions:
1. Filter Incidents Created by New Hires:
- Add a condition to filter the incidents created by users whose sys_created_on or employment start date is within the last 30 days.
Opened by.User [Condition: sys_created_on IS [more than] 30 days ago]
2. Filter Incidents Created within the First 30 Days of Employment:
- Add a condition to check if the incident’s creation date falls within the first 30 days of the user’s employment.
AND Opened by.User [Condition: sys_created_on IS [on or after] [dynamic: First 30 days relative start]]
- Choose how you would like to visualize the report (e.g., List, Bar Chart, Pie Chart).
- You might want to group by Opened by or other relevant fields.
- Save the report and click on Run.
Please Mark this Helpful and Accepted Solution. If this Helps you to understand. This will help both the community and me..
- Keep Learning
Thanks & Regards
Deepak Sharma