Hi @srinivas_366,
The chart behavior in your screenshot usually indicates that the KPI is being calculated over the entire dataset and then repeated for each month, rather than being grouped by a time-series field.
Check the Time Series Field
For task_sla, the most commonly used time-series fields are:
start_time
end_time
planned_end_time
sys_created_on
Choose the field that represents when the SLA achievement occurred. For SLA compliance trends, end_time is typically the best choice because the SLA result is known only when the SLA completes.
Check Aggregation
If your formula is something like:
Achieved SLAs / Total SLAs * 100
make sure the indicator is configured to aggregate per time bucket (Month) and not over all records.
Date Conditions
Avoid hard-coded date filters such as:
end_time >= Last 12 months
inside the indicator source if they prevent proper monthly grouping.
Instead:
- Use the Time Series field = end_time
- Trend by = Month
- Let Platform Analytics perform the time bucketing
Verify the Indicator Source
Run a list filter on task_sla:
Has breached = false
End time by Month
and confirm that the counts differ by month. If the counts vary but the KPI remains identical, the issue is usually in the indicator formula or aggregation settings.
Common causes:
- No Time Series field configured
- Formula indicator using an overall aggregate
- Breakdown by Month instead of a true Time Series trend
- Indicator source returning the same aggregate value for every bucket
For an SLA Achievement % trend:
Table: task_sla
Time Series Field: end_time
Trend By: Month
Aggregation: Count
Formula: Achieved SLA / Total SLA * 100
This should produce different values per month rather than repeating the same percentage across all months.
