95 Percentile OData and On Demand report difference

Products

• CA Performance Management - Usage and Administration
• DX NetOps

Issue/Introduction

When we are running an odata query to get the 95th percentile of the group it is different from an on-demand report for the same metric.

Environment

Release : 22.2

Cause

if you use the metric/id in the Group By portion of the Aggregate function, it calculates the percentile per item in the group and presents an average when calculating the percentile.

Resolution

If you use groups/id in the Group By portion of the Aggregate function the data report will match the on-demand report as it will calculate the percentile of the group:

Example: