search

cityofaustin / atd-data-and-performance

Open data and performance hub for the City of Austin Transportation Department
https://data.mobility.austin.gov
Other
22 stars 8 forks source link

Dockless Card for Unique Devices #224

Closed johnclary closed 5 years ago

johnclary commented 5 years ago

We need to report on unique # of devices by mode (this slipped my mind). This can be captured from device_id

johnclary commented 5 years ago

This query is a little tricky, as SoQL does not support SELECT DISTINCT. A solution might be to select from a sub query that groups by device_id.