SLA Compliance Calculation

In this context refers to creating a calculated measure that evaluates whether each delivery or pickup task adheres to the SLA time (e.g., the expected or agreed duration).

Example Formula for SLA Compliance:

In tools like Power BI or Excel, you can use conditional calculations to evaluate whether tasks meet the SLA threshold.

Power BI (DAX Formula):

SLA Compliance = 
IF(
    [Delivery Duration] <= [SLA Time],
    "On-Time",
    "Delayed"
)

• Delivery Duration: A column in your dataset that calculates the time difference between delivery_time and accept_time.

• SLA Time: A predefined threshold value (e.g., 2 hours or a configurable parameter).

You can then visualize this in the dashboard:

• KPI: Percentage of "On-Time" deliveries.

• Breakdown: Count or percentage of "On-Time" vs. "Delayed" tasks by region, courier, or date.

Excel:

1. Add a Column: Create a new column for SLA Compliance in your dataset.

   • Formula:

     =IF([@[Delivery Duration]] <= [@[SLA Time]], "On-Time", "Delayed")

2. Calculate Compliance Rate:

   • Use a pivot table to summarize and calculate the percentage of "On-Time" tasks.

Slicer Example:

• Add slicers for region, city, courier, or date to filter SLA compliance rates dynamically.

By implementing this measure, you can effectively monitor SLA performance, identify areas of improvement, and communicate with stakeholders about operational efficiency.