Stack Overflow
Stack Overflow

Questions tagged [ms-app-analytics]

In relation to the analytics feature of Application Insights. The query language, chart generation, integration with other tooling ant the API.

Analytics in Application Insights

Analytics is the powerful search feature of Azure Application Insights. These pages describe the Analytics query language:

58 questions
3
votes
3 answers

How to calculate DAU/MAU using Application Insights Analytics?

Assuming I have a definition of a user I can calculate sum of all daily users and all monthly users. customEvents | where timestamp > ago(30d) | where | summarize by , bin(timestamp, 1d) | summarize count() by bin(timestamp, 1d) |…
ZakiMa
  • 5,637
  • 1
  • 24
  • 48
2
votes
1 answer

How to project json key value pair to columns without explicitly specifying name

In customDimensions I have x number of key-value pair data (currently only two Name and Channel as an example in the screenshot below) and I would like to project them to columns without explicitly specify the name of the key, so that in the…
Ming
  • 730
  • 2
  • 8
  • 23
2
votes
3 answers

How to get the Qna Maker "Q" from Analytics Application Insights?

I have created my chatbot's knowledge base with Qna Maker and I am trying to visualize some statistics with Analytics Application Insights. What I want to do I would like to create a chart with the most requested Qna Maker questions. My problem I…
RyanU
  • 128
  • 1
  • 8
2
votes
1 answer

Substring in appinsight

How can I find a Substring in Microsoft AppInsight Analytics? I have event with this template name: "FinalStep-Start: 12:11:20.467 | End: 12:11:20.936" I want to separate those two time, and after that compare them with each other.
hadi arvin
  • 23
  • 3
2
votes
2 answers

App Insights - Empty as zeros

When I use bin(timestamp, 1m) and generate a timechart of it, null values generate a straight line. How can i treat missing values as zeros?!?
Leonardo
  • 10,737
  • 10
  • 62
  • 155
2
votes
1 answer

Application Insights order by aggregate

I have the following query: customEvents | summarize count(datepart("Second", timestamp) ) by toint(customMeasurements.Latency) This is counting the number of seconds past the minute and grouping it by an integer Latency. How do I add an order…
BanksySan
  • 27,362
  • 33
  • 117
  • 216
2
votes
1 answer

MS App Analytics timeline chart

I have data in the following format. Is it possible to create a time line chart using App Analytics. I am trying to easily identify the calls which overlap in my DataSet. | Start Time | End Time | Call Name |…
Praveen Reddy
  • 7,295
  • 2
  • 21
  • 43
2
votes
1 answer

Analytics data deleted from the Azure applicationinsights

I checked that when i try to query on events data the total record decreased automatically. I want to know that when data is deleted from applicationinsights. My query is just simple count query. I also noticed that some events timestamp also…
Navneet Garg
  • 1,364
  • 12
  • 29
2
votes
2 answers

"Failed to resolve 'top' key column" Error in Application Insights Analytics Custom Dimensions

I have some data in Application Insights, and I am using the Analytics view to write queries against it. I can see that I have a trace, the CustomDimensions of which contain a property called ActivityID, which is a guid: What I want to do is now…
Declan McNulty
  • 3,194
  • 6
  • 35
  • 54
2
votes
2 answers

Page results from Azure Application Insights Analytics API

Is it possible to "page" the results from the Analytics API? If I use the following Query (via http POST) { "query":"customEvents | project customDimensions.FilePath, timestamp | where timestamp > now(-100d) | order by timestamp desc |…
Mark McGookin
  • 932
  • 1
  • 16
  • 39
2
votes
2 answers

AIQL Application Insights query how to exclude weekends

In some of my reports I'd like to exclude events that happen on weekends as our app is a business application that isn't running on the weekends, yet we do code updates and resulting tests on the weekends that can skew the data. I've Tried: and…
crichavin
  • 4,672
  • 10
  • 50
  • 95
2
votes
1 answer

Using extend to add a count column in Azure Stream Analytics/Application Insights

I have an Application Insights Azure Stream Analytics query that looks like this... requests | summarize count() by bin(duration, 1000) | order by duration asc nulls last ...which gives me something like this, which shows the number of requests…
ChrisBellew
  • 1,144
  • 2
  • 12
  • 27
2
votes
1 answer

Application Insights Analytics doing sub selects

I am using this reference documentation for Application Insights. How can I do a sub-select using the output of a different query? //Query 1 Events | where Timestamp >= ago(30min) and Data contains('SomeString') | project TraceToken //I would…
Praveen Reddy
  • 7,295
  • 2
  • 21
  • 43
1
vote
1 answer

Application insights - Create a pie chart out of customMeasurements

I create a custom event whenever a job is processed and use a customMeasurement for every file type I can process. tc.TrackEvent("File processed", metrics: new Dictionary{ {…
Menelaos Vergis
  • 3,715
  • 5
  • 30
  • 46
1
vote
1 answer

Kusto sub query selection using toscalar - returns only last matching record

I am referring sqlcheatsheet - Nested queries Query 1: traces | where customDimensions.Domain == "someDomain" | where message contains "some-text" | project itemId=substring(itemId,indexof(itemId,"-"),strlen(itemId)) Result…
Mohammed Yasin
  • 739
  • 6
  • 14
1
2
3 4