Analytics - totalResultCount()

Gregory_Burkhea — Thu, 15 Feb 2024 14:21:09 GMT

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.

Re: Analytics - totalResultCount()

iamryan — Thu, 15 Feb 2024 19:18:56 GMT

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-functions

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'

topic Analytics - totalResultCount() in Splunk AppDynamics

Analytics - totalResultCount()

Re: Analytics - totalResultCount()