Pie chart with uniqueCount adds up to more than 100%

Problem

When using a pie chart with the uniqueCount aggregator function, the percentages add up to more than 100%.

Solution

Using a bar chart or table may provide a more accurate visualization of uniqueCount data.

Cause

The attributes being uniquely counted may be present in multiple facets. This overlap may result in the facet percentages adding up to more than 100%.

For example, in the query SELECT uniqueCount(user) FROM PageView FACET appName, a single unique user may use multiple applications. Each of these users will be included in the unique value for each of the appropriate facets (applications), but the total number of unique users will not change.

crop-pie-chart-uniquecount.png
insights.newrelic.com > Query > (query using uniqueCount): Pie charts using uniqueCount can produce percentages that add up to more than 100%. In this example, you have 200 unique users. Of those, 198 of those users (99% of 200 unique users) have accessed your "Account" app, and 196 users (98% of 200 unique users) have accessed your "Store" app.

For more help

Recommendations for learning more: