{"type":"video","version":"1.0","html":"<iframe src=\"https://www.loom.com/embed/73b1e992f495403f8900ed69d3e183d7\" frameborder=\"0\" width=\"2560\" height=\"1920\" webkitallowfullscreen mozallowfullscreen allowfullscreen></iframe>","height":1920,"width":2560,"provider_name":"Loom","provider_url":"https://www.loom.com","thumbnail_height":1920,"thumbnail_width":2560,"thumbnail_url":"https://cdn.loom.com/os/loom-media-content/loom/b0ef9efb-c6d7-4703-a7be-1fd3c2584a2e/56ff5e97-1a27-4c05-93e3-a38931e961a8/sessions-thumbnails-73b1e992f495403f8900ed69d3e183d7-e959a941faef9f06.gif/binary?authToken=eyJraWQiOiJtaWNyb3MtZ3JvdXAvdGRwLW9zLWFyY2hldHlwZS84dW03YzdlcWJybWdhNnB1IiwiYWxnIjoiUlMyNTYifQ.eyJicyI6Imxvb20tbWVkaWEtY29udGVudCIsImF1ZCI6InRkcC1vcy1hcmNoZXR5cGUiLCJuYmYiOjE3OTQ2OTA3NzMsInRpIjoiNjI0M2IxMzgtZGRkNy00NGZiLTkzMzYtMWM5YWMyNjMzYzE3IiwiYWRpIjoibG9vbS9sb29tIiwiaXNzIjoibWljcm9zLWdyb3VwL3RkcC1vcy1hcmNoZXR5cGUiLCJwaWQiOiI0NzZkNzQ2Ny02NTIwLTQ3YzgtOTYwNy03NzU4MTRhZmZmOGUiLCJ3YSI6ImZhbHNlIiwib2lkIjoic2Vzc2lvbnMtdGh1bWJuYWlscy03M2IxZTk5MmY0OTU0MDNmODkwMGVkNjlkM2UxODNkNy1lOTU5YTk0MWZhZWY5ZjA2LmdpZiIsImV4cCI6MTc5NDY5MTM3MywiaWF0IjoxNzk0NjkwNzczLCJqdGkiOiJhNTU4NzcwYi1jZTI5LTQzZDgtOWRkMC1iYjVlOTUwNDc5NTIifQ.PQYel7536O39F4XrPFTxTyyxAP4lmdkNrUB8pr4RYYTXypWNc7bdxJjbmP-J-FZb_pnE7nzSkDgKopjIiOvZC1NtGNNElcuU8wCWjj8tPNuPLUQ05o8DSOD54Ooh8fd6A4lzltwXraJjKYWmOIJgIjafxW4p8GWRSX46QNaXaPU3wjmwPrpEcVbmiALDnbfthalYqTXKDRs5PVwgCgriP5Z7AJJ7_7k28Tup6ftbywyV-VK7TMNB3T620AXkRjsLItcGq-v79xPSZlKestU2jRmz8J5S9y2ShlD5IMmWTOzEwZHXKusjatTBQvlAAeIgULuitVJ3ZjxM6nrIO5uuOg&Expires=1794691374&Signature=NE8hKltIz9HTrHhP3JTVGNn6Pv2XDhHDnEnqaAuKjB7NkfA-zAEQo8T33kJqo3ngI%7E7jNmk1b%7EXYCrpeC5ZAMuAryAN1qLeAU%7EQo0JTAwNI2Wb6p5c68hI5pKsXImc7GVpFcAKQlg2sfOOCahXMFUxmS8LTpqaMGM3lhh4xQHBc9U%7Eq2wX1SBpiJptow3mR8M9hfFEMBGFfyRth2WB8NW9Ws-OSQmaJDrEqNSAjZfH53SFK3BqOiugaTsXcf-wheNAWv0JU725s0mkp-uJovXvbxaYN9C9Zr2dx%7EAx38tH-jkUXFYGbmvYumQ1MBhXOeCgYZa5QObad7LRv2%7E-eM-g__&Key-Pair-Id=KQOSYIR44AIC0","duration":767.633333,"title":"Fixing Dashboard Errors, Timezones, Tenants, Precision","description":"This Loom explains how Abdul Hadi reproduced and fixed errors in a dashboard used to manage property reservations across time zones and tenants. He traced a February to March reporting discrepancy to UTC-stored reservation dates that were not respected for properties in Paris, then updated the SQL revenue summary logic to join on the property time zone and validate by rebuilding the container and confirming the correct month display for property 1. He then investigated tenant data leakage between client A and client B by comparing API responses and fixed it by updating Redis caching to namespace by tenant ID, property ID, year, and month. Finally, he addressed a floating point precision mismatch by switching the calculation to decimal with quantization and rounding half up, reducing the error to a maximum half a cent for the affected property."}