Analytics - totalResultCount()

[Gregory_Burkhea]

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.

[iamryan · Accepted solution]

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.

https://docs.appdynamics.com/appd/onprem/latest/en/analytics/adql-reference/adql-queries/analytics-f...

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'