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!!
Solved! Go to Solution.
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.