SELECT id, project_name, metric_name, "time", value, display_value, geometry_id
FROM public.metrics_app_timeandgeometric
where project_name = 'Lasswade'
and metric_name in ('peopleCount', 'Occupancy', 'Utilisation')
and geometry_id in (1210, 5127)
and display_value is NULL
and time > '2022-12-08'
order by time, metric_name
Preview:
downloadDownload PNG
downloadDownload JPEG
downloadDownload SVG
Tip: You can change the style, width & colours of the snippet with the inspect tool before clicking Download!
Click to optimize width for Twitter