Reports

RodolfoT
Kilo Contributor

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? 

1 REPLY 1

Deepak Shaerma
Kilo Sage

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

Tableincident
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