How to plot multiple points

[will.morris]

i have a data set with the latitude and longitude of around 60 points and when i enter the
{{ query.data }} into the points part of the map it only displays one point i assume it is just something small and obvious that i am missing. Thanks

[kschirrmacher]

Are you transforming the result of that query at all? That component is expecting an array of objects with, at the very least, latitude and longitude keys and values but SQL queries return an array per column.

It looks like using return formatDataAsArray(data) in the query transformer would work for this, as well as removing the array brackets from around getPubLocations.data in the points field. You may have to remove Pub_name from the select as well.

[will.morris]

Thank you