Hello everyone !
I would like to do an advanced query by the Rest API which look like something like this :
SELECT CAST(AVG(nbr_trip) AS integer)
FROM (
SELECT id_people, count(id_trip) AS nbr_trip
FROM base.trip
GROUP BY id_people
ORDER BY id_people
) AS tmp_query
My goal is to return back only a number which is the average of a count but the REST UI doesn't seem to allow me to do that...
Someone could help me please ?
Thx by advance !
Florian, you may want to "share" this question with ArcGIS REST API too (you can share without re-asking ...or add tags)
That group might have more insight.
Thx for the guidance Rebecca, I didn't saw there was this topic !
Allo ? No-One knows nor can help me ?