cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Not a customer? Start a free trial

Click the Start a free trial link to start a 15-day SaaS trial of our product and join our community as a trial user. If you are an existing customer do not start a free trial.

AppDynamics customers and established members should click the sign in button to authenticate.

Business iQ (Analytics)

Change the name of return values of an ADQL query

Arthur.Oliveira
Builder

Change the name of return values of an ADQL query

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)
By replying you agree to the Terms and Conditions of the AppDynamics Community.
Change the name of return values of an ADQL query
2 REPLIES 2
Bob.Bers
AppDynamics Team

Did you solve this yet?

Arthur.Oliveira
Builder


@Bob.Bers wrote:

Did you solve this yet?


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