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
45
votes
1 answer

Application Insights - How to sort by custom dimension

I would like to sort the results of my query according to customDimension.MyCustomProperty which is present in all entities and is a number. How can I do that?
Leonardo
  • 10,737
  • 10
  • 62
  • 155
31
votes
2 answers

Application Insights Extract Nested CustomDimensions

I have some data in Application Insights Analytics that has a dynamic object as a property of custom dimensions. For example: | timestamp | name | customDimensions | etc…
Seafish
  • 2,081
  • 2
  • 24
  • 41
13
votes
1 answer

Application Insights: Analytics - how to extract string at specific position

I'd like to do, Extracting "query" strings where param=1 as follows in "2." Getting pageViews in Analytics with table as "3." 1. Actual urls included in…
grantaka36
  • 277
  • 1
  • 2
  • 14
12
votes
4 answers

Azure Application Insights Query - How to calculate percentage of total

I'm trying to create a row in an output table that would calculate percentage of total items: Something like this: ITEM | COUNT | PERCENTAGE item 1 | 4 | 80 item 2 | 1 | 20 I can easily get a table with rows of ITEM and…
mpnap
  • 153
  • 1
  • 1
  • 8
9
votes
2 answers

How to use mvexpand on an json array of key/value pairs

I have a custom property in my appInsights telemetry that is a json array of a key/value pairs. What I want to do is project out that key/value pair and it seems that using parsejson and mvexpand together is how to achieve this; however, I seem to…
Tedford
  • 2,842
  • 2
  • 35
  • 45
5
votes
1 answer

Check if a value is not in a list in Application Insights Query Language?

Is there a shorter way to check if a property, say user_id is not within a given list: customEvents | where user_Id != 123 and user_Id != 234 and user_Id != 345
Mikkel R. Lund
  • 2,336
  • 1
  • 31
  • 44
4
votes
1 answer

Microsoft App Center: How get list of users with session duration?

In the Microsoft App Center, I need to get a list of users who have spent the most time in the game. However, I did not see App Center providing information about individual users and receiving them. One of the similar functionalities that I saw was…
Nikita Goncharuk
  • 795
  • 1
  • 8
  • 23
4
votes
1 answer

Get unix timestamp Azure App Insights

How would I project the unix timestamp for when my data was logged in Azure through Azure App Insights? I know I can use now() to get the current timestamp, but what about the timestamp of a row?
perennial_
  • 1,798
  • 2
  • 26
  • 41
4
votes
1 answer

Application Insights Analytics - Query union of 2 or more tables

How can I union tables and then apply a where filter? basically i want to find all items with the operation_Id == X
Leonardo
  • 10,737
  • 10
  • 62
  • 155
3
votes
0 answers

Xamarin iOS build crashes only on TestFlight

I have an app that has been working fine in production and on Testflight. However, recently our customer upgraded to iOS 15 and the app started crashing for them on startup. I looked into this and was able to reproduce the crash by deploying…
Jonathan Cook
  • 31
  • 2
3
votes
1 answer

Filter Custom Dimension with Period in Property Name

Following this guide, I see how to filter on custom dimensions but how do I filter when there is a '.' in the key / property name? For example, I want to filter on ServiceFabric.ServiceTypeName from this custom dimension value: { …
spottedmahn
  • 14,823
  • 13
  • 108
  • 178
3
votes
1 answer

Application Insights Join/Combine Columns Into A Single Column

I have an application insights query. And in this query I want to join/combine several columns into a single column for display how can this be accomplished. I want to combine ip, city, state, country. customEvents | where timestamp >= ago(7d) |…
Piotr Zaremba
  • 195
  • 2
  • 9
3
votes
1 answer

Azure Application Insights Queries to share the same variable

I have an AI dashboard with a number of queries displaying the last run results. Every query does something like that: let lastRun = customMetrics | where session_Id != '' | top 1 by timestamp desc | project session_Id; customMetrics | where…
marikvntu
  • 41
  • 1
  • 5
3
votes
2 answers

Application Insights, convert time difference to milliseconds

How can I convert time difference into milliseconds in Azure Application Insights let startTime = todatetime('2017-05-15T17:02:23.7148691Z'); let endTime = todatetime('2017-05-15T17:02:25.5430172Z'); let timeDifference =…
Praveen Reddy
  • 7,295
  • 2
  • 21
  • 43
3
votes
1 answer

Retrieve distinct rows after a join

I am performing a join between two events as follows. How can I get distinct rows in my final output? let fromdate = "2017-04-26 23:00"; let fileEvents = (Events | where Timestamp > todatetime(fromdate) | project fileId, fileName,…
Praveen Reddy
  • 7,295
  • 2
  • 21
  • 43
1
2 3 4