Azure Monitor
An Azure service that is used to collect, analyze, and act on telemetry data from Azure and on-premises environments.
3,666 questions
This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
When I run the following query on app insights I get different results for every run
let allEvents=customEvents
| where timestamp between (datetime('2022-12-30')..datetime('2022-12-31'));
allEvents
| where name == "Event1"
| project st1 = timestamp,user_Id
| join kind=innerunique (
allEvents
| where name == "Event2"
| project st2= timestamp,user_Id
) on user_Id
| where st1 < st2
| summarize count()
I few further observations
Closing this. Upon reading the documentation further, I guess by definition innerunique will pick a random row if there are multiple to use for the join. That explains it