{"type":"video","version":"1.0","html":"<iframe src=\"https://www.loom.com/embed/fb626c43662f4bb3822464ad68c85f10\" frameborder=\"0\" width=\"1080\" height=\"810\" webkitallowfullscreen mozallowfullscreen allowfullscreen></iframe>","height":810,"width":1080,"provider_name":"Loom","provider_url":"https://www.loom.com","thumbnail_height":810,"thumbnail_width":1080,"thumbnail_url":"https://cdn.loom.com/sessions/thumbnails/fb626c43662f4bb3822464ad68c85f10-00001.gif","duration":222.57,"title":"How to Export and Analyze Asset Data in Sonar 📊","description":"In this video, I will guide you through the process of exporting the asset list from Sonar and applying a formula to identify assets with multiple beacons attached. I will demonstrate using a small subset of data, making it easier to understand. We will export the list to Excel and locate the beacons column. I will show you how to insert a new column and apply a formula to calculate the beacon count. Additionally, I will explain how to adjust the formula if the column position changes in future Sonar updates. Finally, we will analyze the data and verify the accuracy of the results."}