Preview:
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
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