I'm trying to convert the data to lat long coordinates in the looker, but I can only draw the polygon by circular points.

I would like the drawing to be in polygon format, but it is coming as circles, if i join the dots, the polygon is totally wrong the polygon design.

  dimension: bounds {
    type: location
    sql_latitude: ST_Y(ST_Centroid(ST_Transform(${TABLE}."bounds", 4326)));;
    sql_longitude: ST_X(ST_Centroid(ST_Transform(${TABLE}."bounds", 4326)));;
  }
1 Like

I have the same doubt, I need help with this too!!!