|
Group: Forum Members
Posts: 5,
Visits: 17
|
Hello,
I would have liked to create the following query to get an http response time distribution
SELECT 'bigger than 3sec', count(*) as nbrequestbelowtime, (SELECT count(*) as nb_of_request_total FROM CurrentView where cs-uri LIKE '%/suite/sites/cpr%') as total
FROM CurrentView
where cs-uri LIKE '%/suite/sites/cpr%' AND time-taken > 3000;
but after a while i get the following error
---- Query Failed ----
Unable to interpret SELECT statement. Field, function, or expression expected.
What could be wrong with this query ?
|