Pie chart with uniqueCount adds up to more than 100%


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


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


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.

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

If you need more help, check out these support and learning resources: