Discussion Feed

kyzhou · ‎04-17-2018

No, I do not have an EUM license. I was asking for Analytics tables in general. How should we structure a search to select from multiple tables? Do they need to share the exact same rows, or just a subset?

kyzhou · ‎04-16-2018

The tables I wish to select from are custom event schema created through the Analytics API. Both synth_session_records and browser_records give the same error: Failed to receive query results [HTTP 401 Unauthorized]. I can only select results from transactions.

kyzhou · ‎04-12-2018

I am still told that the query is unauthorized. Perhaps the query you have given does not work for on-premise Controllers? I copied and pasted the query you provided and tried for the pageurl: <domain>:8090 <domain>:8090/controller <domain>:9080 But none return any results. In general, what criteria do you need to satisfy to be able to select from multiple tables? For example, does synth_session_records also have matching fields for pagename and metrics.`End User Response Time (ms)`?

kyzhou · ‎04-11-2018

Is it possible to manually change the colors in a graph created through the custom widget builder? I would like to change some of the bars to red to indicate that they represent errors occuring.

kyzhou · ‎03-23-2018

Analytics is usable for me.. queries to my custom schema work as expected. This only occurs for the two tables involved in the query example that was provided above.

kyzhou · ‎03-22-2018

Hello Chitra, Could you explain a little further on how to select from two different tables? I tried on my existing two tables a query: SELECT nameTable.id, nameTable.names FROM dataTable WHERE nameTable.id = "1" but was given an error: Unrecognized field [nameTable.names] not found in schema Also, I could not query the synth_session_records, I was given a 401 unauthorized.

kyzhou · ‎03-21-2018

I have a table of IDs to Names: id: name 1: user1 2: user2 3: user3 and another table of more data: id: edu : ...... 1 : bachelor : .... 2 : master : .... 3 : phd : .... Is it possible to use AQL to join these two together so I can display the name corresponding to an id in a search?

kyzhou · ‎03-14-2018

Also, the documentation states that an analytics search metric will execute once per minute. Is it possible to schedule a query to run more frequently than once per minute?

kyzhou · ‎03-14-2018

Another question, if we update an existing schema to include more fields, what would happen to our existing data? Would it be treated as if we had deleted the old schema and created a new one, removing all of our prior data, or would they continue to be stored? Likewise, if we updated a schema to delete fields, what would happen to the events we already ingested?

kyzhou · ‎03-13-2018

Thanks, once I published some events I could see the schema showing up as an additional table. In the UI would we also be able to delete the table, or must that be done through the API as well?

Date Registered	‎02-08-2018 11:13 AM
Date Last Visited	‎04-28-2018 11:01 AM
Total Messages Posted	30
Total Kudos Received	1

Discussion Feed

Re: Is it possible to join tables using AQL?

Re: Is it possible to join tables using AQL?

Re: Is it possible to join tables using AQL?

Is it possible to manually set colors for custom w...

Re: Is it possible to join tables using AQL?

Re: Is it possible to join tables using AQL?

Is it possible to join tables using AQL?

Re: Where can I find custom event schema in the Co...

Re: Where can I find custom event schema in the Co...

Re: Where can I find custom event schema in the Co...