Distance Calculation Using Latitude and Longitude in AWS QuickSight

[Surendar]

Dear Team,

I would like to inquire if it is possible to calculate the distance between two points using their latitude and longitude coordinates directly in AWS QuickSight. If this functionality is available, could you please provide the details or formula for creating a calculated field to achieve this?

Thank you for your assistance.

Thanks for your support

[Sanjeeb2022]

Hi @Surendar - Thanks for the question. Can you please have a look on the below blog -

How to plot a radius in Quicksight

How to plot a radius in Quicksight Sometimes analyses require extending the analytical focus from one point on the geospatial mapping (be that an exact location or a city) to a larger circled area around that one point. Calculating precise distances between two points on Earth that take altitude and the exact special curvature of the Earth into consideration (note that Earth is not a perfect sphere) requires special formulas which are not currently available in Quicksight. However, for small di…

Regards - Sanjeeb

[Surendar]

Hi Sanjeeb,

I hope you’re doing well.

I wanted to discuss a scenario where we need to calculate the distance between two sets of geographic coordinates. Specifically:

• We have one table containing Visit Latitude and Visit Longitude.
• We have another table containing Outlet Latitude and Outlet Longitude.

We need to compute the distance between each visit and its corresponding outlet to determine how far each visit is from the outlet.

Could you advise on how we might achieve this calculation? If there are any specific methods or formulas you recommend, please let me know.

Thank you for your help.

[Javier_Galvis]

It’s not… QuickSight can’t compute operations such as SIN and COSINE.

We’ve been waiting for this for years and ended up going with performing the calculations out of QuickSight using SQL. It’s a pain but is the only way we’ve found.

If it wasn’t for the time we’ve spent in development and training our over 300 readers, we’d have moved to a different tool.

[ArunSanthosh]

Marking @Sanjeeb2022 's response as the solution.

Regards,
Arun Santhosh
Pr QuickSight SA