Add 'AVG' aggregation for Stats Queries

Bug #1582810 reported by Anish Mehta
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Juniper Openstack
Status tracked in Trunk
Trunk
Fix Committed
Medium
Nikhil Bansal

Bug Description

We have a "SUM" aggregation in Stats Queries (for counters), but no "AVG" aggregation (for dials)
This needs to be added.

The need is currently being met by supporting "SUM" and "COUNT", and dividing SUM by COUNT, but this is problematic for two reasons:

1. It is inconvenient for the user to ask for two aggregations when they are really interesting in AVG.
2. The calculation is incorrect for optional attributes - the "SUM" only adds the attribute when present, but the "COUNT" counts all samples of the Stat - even those that don't have any contents for the optional attribute.

Tags: analytics
Jeba Paulaiyan (jebap)
information type: Proprietary → Public
Raj Reddy (rajreddy)
Changed in juniperopenstack:
importance: Wishlist → Medium
assignee: Raj Reddy (rajreddy) → Nikhil Bansal (nikhilb-u)
Revision history for this message
OpenContrail Admin (ci-admin-f) wrote : [Review update] master

Review in progress for https://review.opencontrail.org/20855
Submitter: Nikhil Bansal (<email address hidden>)

Revision history for this message
OpenContrail Admin (ci-admin-f) wrote : A change has been merged

Reviewed: https://review.opencontrail.org/20855
Committed: http://github.org/Juniper/contrail-controller/commit/244190f2ae28a2aef77e7bbbb908c0e4cdb4f4ac
Submitter: Zuul
Branch: master

commit 244190f2ae28a2aef77e7bbbb908c0e4cdb4f4ac
Author: Nikhil B <email address hidden>
Date: Thu Jun 2 09:00:48 2016 +0530

Adding AVG aggregation in stat queries

Earlier, there were SUM, COUNT, MIN, MAX and PERCENTILE options for
aggregation of stats. This change will add AVG there
Closes-Bug: #1582810

Change-Id: I518a0357a22047d69a415be03aff4d4e4318d3fa

To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.