Forum Discussion

Deleted's avatar
Deleted
Dec 22, 2017

Remove Duplicate Events in Group

Goal: Query AppInsights data for the pages a user has viewed over the course of their session.

The problem is that there are duplicate page views, each with the same timestamp. In the query below, I `sort by session_Id, timestamp` and that data shows a ton of duplicate urls in each session. If I can run `distinct timestamp` for each session, it would eliminate that duplication.

 

Any way I can do this? 

 

```

pageViews
| sort by session_Id, timestamp
```
  • This seemed to do the job
     
    ```
    pageViews
    | summarize by session_Id, operation_Name, bin(timestamp, 1tick)
    | sort by session_Id, timestamp asc

    ```

Resources