Showing results for 
Show  only  | Search instead for 
Did you mean: 

Analytics - totalResultCount()

Can someone help me understand the totalResultCount function?

I have looked at the documentation and spent an hour or two fiddling with it, but I can't figure out what it is supposed to do.


Community Manager

Hi @Gregory.Burkhead,

I'm going to dig into this for you, but I wanted to make sure this was the documentation you were looking at.

This explanation does not tell you enough? 

This query first selects all error transactions for the "ECommerce" application. It then calculates, for each unique transaction name, the ratio of instances of that transaction name to the total number of error transactions. (The assumption is that any given transaction name can appear in multiple error transactions.)

SELECT transactionName, count ( * ) / totalResultCount() FROM transactions WHERE application = 'ECommerce' AND userExperience = 'ERROR'


Ryan, Cisco AppDynamics Community Manager

Found something helpful? Click the Accept as Solution button to help others find answers faster.

Liked something? Click the Thumbs Up button.

Check out Observabiity in Action

new deep dive videos weekly in the Knowledge Base.