Hi @SuperSalmon,

To create a graph or visual that compares the Due Date for Requests and Incidents against 'Today's Date' and indicates whether a ticket is within or has failed your SLAs, follow these steps:

1. Log in to SysAid Admin Portal:

• Use your admin credentials to log in to your SysAid account.

2. Navigate to the Analytics Module:

• Go to the 'Analytics' or 'Reports' module where you can create and customize reports.

3. Create a New Report:

• Click on 'Create New Report' or a similar option to start building your report.

4. Select the Data Source:

• Choose 'Service Records' as the data source for your report.

5. Define the Report Criteria:

• Set the criteria to include both Requests and Incidents.
• Add a filter to compare the Due Date with 'Today's Date'. You can use expressions like Due Date < Today to identify tickets that have failed the SLA.

6. Add Visualization Elements:

• Choose the type of graph or visual you want to use (e.g., bar chart, line graph, pie chart).
• Configure the visual to display the comparison between Due Dates and 'Today's Date'.
• Use color coding or labels to indicate whether a ticket is within or has failed the SLA.

7. Save and Run the Report:

• Save your report and run it to generate the visual.
• Review the visual to ensure it accurately represents the SLA status of your tickets.

If you need more help, have further questions, or just want to chat about this topic, please don't hesitate to reach out.

Thanks so much for your quick response @simonamirza.

I’m relatively new to the Reporting side of SysAid having recently been appointed to the role of Service Desk Supervisor and with my appointment comes the formal introduction of SLAs.

Is there a way I can set the reports date to ‘Today’ whenever the report is ran rather than hard-code a date?

Also would you mind going into the graph side of things in a bit more detail? I’m unclear on how/where to input the comparison between the two dates and display that as a visual.

Many thanks,

Mel S.