Business iQ (Analytics)
cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

Forum Posts

Query to get time spend in a flow of pages

We have a shop flow consiting of a number of pages, and I need to track the sum of avg. response time for all pages in flow. E.g. the flow consists of: Page 1: avg. end use response time of 3 sec. Page 2: 4 sec. Page 3: 2 sec. So total time for flow ...

ADQL for doing UNION query

I need to compute the number of distinct users across both mobile and web application.    For web alone I get the number using this query - SELECT distinctcount(userdata.userId) FROM browser_records   And for mobile using this -  SELECT distinctcount...

Analytics Query Total Page #

Hello, I have been testing out our analytics feature and am having a problem. I’m trying to fetch a list of the top 20 EUM applications based on the total # of page requests outside of the U.S. for a duration of one year. I have figured out how to na...

Q1.png Q2.png

Resolved! Log Analytics

Hi All! I am trying to understand the log analytics features. Can I import any kind of log and do analytics on them? According to the link and picture below I can import networking (switches,routers) and VMware or even LDAP or Load balancer logs as w...

image.png

Why is the filter not being honored in ADQL?

This query should be limiting the data returned to items that have "*xpense*" in their url:   SELECT segments.httpData.url, userExperience, count(*) FROM transactions WHERE (transactionName like "*expense*" OR transactionname like "*Expense*") and us...

Transaction Analytics not showing up

Greetings, Could anyone please help me out with installing anaIytics extension of the standalone machine agent? I installed machine agent in my windows server and turned on the analytics feature and filled out the required info in the Analytics Agent...

Resolved! How to use 'distinctcount' clause in ADQL

hello folks,   I want to basically get count of distinct 'fieldname' . When I write the following query, it won't work.   SELECT distinctcount(bb) FROM transactions WHERE application = "PROD" AND transactionName = "aaa" AND segments.userData.eReceipt...