Business iQ (Analytics)

cancel
Showing results for 
Search instead for 
Did you mean: 

Change the name of return values of an ADQL query

Highlighted

I'm trying to use Analytics to get how many access each page on my website is receiving and I want to see that information divided by customer. I managed to collect all the data I need and show it in a graph using the following query:

 

SELECT segments.userData.CodPagina AS 'Page name', segments.userData.RazaoSocial AS 'Customer', count(*) AS 'Number of visits' FROM transactions WHERE application = "frotas.localiza.com/MyFleet" and segments.userData.RazaoSocial is not null and segments.userData.CodPagina IN (29, 50, 5, 8, 11, 14, 4, 18, 3, 40) and segments.userData.CodPagina != 273

 

My problem is: "codPagina" is the ID of each page in the application code, but I need to replace the number with the actual name of the page. Is there any way I can do that correlation in the query?

Tags (2)
Change the name of return values of an ADQL query
2 REPLIES 2
Highlighted
AppDynamics Team

Did you solve this yet?


@Bob.Bers wrote:

Did you solve this yet?


Hi Bob, unfortunately I havn't been able to find a solution for this :(