what is the type of duration in PageViews result in AppInsights Query is it Seconds, MilliSeconds Or Minutes?

Question

what is the type of duration in PageViews result in AppInsights Query is it Seconds, MilliSeconds Or Minutes?

Vinod Lokanatha (Harman Connected Services) 65 Microsoft External Staff

below query gives me results of timespent based on duration, i would like to know what is the type of this duration ?


let startTime = datetime(2026-01-09T00:00:00Z);
let endTime   = datetime(2026-01-19T23:59:59Z);
let targetPage = "RevenueForecast";

pageViews
| where timestamp between (startTime .. endTime)
| where url has targetPage
| where user_AuthenticatedId in ("xxxxx")
| summarize
    timeSpent = sum(duration)
    avgTime   = avg(duration),
    // viewCount = count()
  by user_AuthenticatedId
| order by timeSpentinMins desc

0 comments

Answer accepted by question author

0 additional answers

Your answer

Answer 1

In Application Insights, the duration property for pageViews is represented as a TimeSpan. This means that the duration is typically measured in milliseconds, as TimeSpan can represent durations in a variety of formats including days, hours, minutes, seconds, and milliseconds. Therefore, when you query the duration in your Application Insights data, it is effectively in milliseconds.

References: