ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

Running Same Report Can Output Slightly Different Data

book

Article ID: 133646

calendar_today

Updated On:

Products

CA Infrastructure Management CA Performance Management - Usage and Administration

Issue/Introduction

Reports for metrics such as 95th percentile are showing very small  (.01 difference) when run repeatedly

Cause


The functionality of the Vertica APPROXIMATE_PERCENTILE function

https://www.vertica.com/blog/database-approximate-median-percentile-functions/

Environment

Release :

Component : IM Reporting / Admin / Configuration

Resolution

You can see small variances in the data due to the use of the APPROXIMATE_PERCENTILE function in the percentile queries.