Dec 22 2017 09:12 AM - edited Dec 22 2017 10:44 AM
Dec 22 2017 09:12 AM - edited Dec 22 2017 10:44 AM
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?
```
Dec 22 2017 10:45 AM
Dec 22 2017 10:45 AM
```