How do we convert latitude and longitude to geo point?
We have source data by postal code that we want to plot with a GIS Bubble Map. We also have a lookup table that has postal codes and latitude/longitude values so we can map postal codes to locations.
My question is: How can we convert those latitude and longitude values to a GIS Point for use in the bubble map? I saw the following article but it seems to be specific to the JSON connector: https://community.yellowfinbi.com/knowledge-base/article/how-do-you-convert-separate-latitude-longitude-values-into-a-point-value-for-mapping
What format and data type does the data need to be in from a Postgres source for us to be able to have a GIS geo point field in our view? How is that configured in the view?