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

usql timeseries

3ndalaust
Participant

Hi everyone, I'm just wondering how can I visualize this query "select count(targetUrl) from useraction where targetUrl="https://something.com/logininPage?auth=failure" as a timeseries instead of a single value visualization.


Thank you so much!!

1 REPLY 1

y_buccellato
Advisor

My friend, you mean usql? Or is it a new feature I'm not aware of? 🙂

I think this can be a starting point from what you want to achieve:

SELECT DATETIME(startTime, "yyyy/MM/dd HH:mm", "5m"), COUNT(targetUrl) AS "Number of time targetUrl was called in an interval of 5minute" FROM useraction WHERE application="Myapplication" AND usersession.userType IS "REAL_USER" AND targetUrl = "http://www.partytime.org/veryhappy" GROUP BY datetime(startTime,"yyyy/MM/dd HH:mm","5m")


Let me know