usql compare with last week

3ndalaust — Tue, 05 May 2020 16:09:37 GMT

Hi everyone, how can I compare my query results from this week from the last one.

for example: "select datetime(starttime, "yyyy/MM/dd", "5m"), count(targetUrl) from useraction where targetUrl = "https://something/main/login" group by datetime(starttime, "yyyy/MM/dd HH:mm", "5m")"

Thanks a lot for your time!!

Re: usql compare with last week

JamesKitson — Tue, 05 May 2020 17:07:16 GMT

Use the comparison toggle underneath the usql query. Also not you'll likely need to modify the format of your datetime function like my example if you're interested in resolution higher than per day.

topic usql compare with last week in Real User Monitoring

usql compare with last week

Re: usql compare with last week