cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

usql compare with last week

3ndalaust
Participant

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!!

1 REPLY 1

JamesKitson
Dynatrace Leader
Dynatrace Leader

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.