video1.0<iframe src="https://www.loom.com/embed/66c33e3c2d8a419e8771cbcdcdbf50c7" frameborder="0" width="3320" height="2490" webkitallowfullscreen mozallowfullscreen allowfullscreen></iframe>24903320Loomhttps://www.loom.com24903320https://cdn.loom.com/os/loom-media-content/loom/7acaaede-600c-4507-9afd-e1a0c5a6ca06/87fd147b-641e-4524-b9f5-814a4ee3e27d/sessions-thumbnails-66c33e3c2d8a419e8771cbcdcdbf50c7-5ddd9018e67914e4.gif/binary?authToken=eyJraWQiOiJtaWNyb3MtZ3JvdXAvdGRwLW9zLWFyY2hldHlwZS84dW03YzdlcWJybWdhNnB1IiwiYWxnIjoiUlMyNTYifQ.eyJicyI6Imxvb20tbWVkaWEtY29udGVudCIsImF1ZCI6InRkcC1vcy1hcmNoZXR5cGUiLCJuYmYiOjE3OTQ2OTA3NzMsInRpIjoiMzliYzEyMmUtYjUzYS00NTU2LWE0ZjAtZjkzOWY4ZDZkNGYyIiwiYWRpIjoibG9vbS9sb29tIiwiaXNzIjoibWljcm9zLWdyb3VwL3RkcC1vcy1hcmNoZXR5cGUiLCJwaWQiOiI1NjQxMDkwMC0yMTg3LTRiN2EtOGE5Mi0wNWNhOTFmMWZkOTgiLCJ3YSI6ImZhbHNlIiwib2lkIjoic2Vzc2lvbnMtdGh1bWJuYWlscy02NmMzM2UzYzJkOGE0MTllODc3MWNiY2RjZGJmNTBjNy01ZGRkOTAxOGU2NzkxNGU0LmdpZiIsImV4cCI6MTc5NDY5MTM3MywiaWF0IjoxNzk0NjkwNzczLCJqdGkiOiI2NDgyYmZkYS1lNjI0LTRkNzktODJiYS0yNTJiMjhlN2M4NzcifQ.mQqecqmN99c1Rk6mLMURmT2N0z3qP3owOv7xk2QcQUP5qudwr-MQhiLav3ySgAsv_diK_REhNVdBcc0dFWpdrlPTRauwhS6gS3sPifFM_DNKoXQZuqkN-YUA7jmbBHQDR_8n03vigcVBTQdNVUx_TWOVnCl5AoexuDgAlEJdpYAutyZHX4P3FoRs3mWAn0CtXJ8buqWTy0ZJO2SXzYl3aj9UY3N7_jYLCzDbjuO1ZyBy76wALsySjJesEH8kAWej-dYJXZA9oaE4JsE-VNRFutGVnVA9UeQ95r_qdvuLbpc1NsJPqu0kUH-q6M5vVoz6V-yowrUt28UFdBg4NLe6XQ&Expires=1794691373&Signature=VcNYaoP7SqA%7E3NHOTewcM6YPgOsjZIfsMMPwaGCXjInl4xZGM-ioNYNILsRAZByoXVuo7JcZenDqf0qXA2x2Uw0x-g1MAauTocUuooJ21mlIAMowx%7EaVnKYenxT8Fmt6KTCNvTG%7ERDGVz3RSd5IW-5buUH1r9YUe7WYQR0ZDX82Fp9ugrTUiemWGniCoP2uedNkip%7EsEzm7nzVHfV3SwoM4bVEN6fRGHRUd4sezTgBysvjUglZlAF-c8XmNak6yOds4yAA03HwFzg%7Edbds0h6xIsDbofl1yZyvVO885iUM9Fw5Q-61oENLs8lBCi3GYKYCAn0Kt2cIeZ0fw6hPl1%7EA__&Key-Pair-Id=KQOSYIR44AIC0598.148This Loom focuses on debugging revenue dashboard cross-tenant privacy leakage and related calculation issues. The candidate explains that cached Redis data was shared across tenants, so when tenant A loads first it fills the cache and tenant B sees tenant A properties for about five minutes; the fix is to scope cache rows by Tenant ID. They also address incorrect March totals caused by using a naive UTC month window instead of each property time zone, proposing a UTC conversion based on March 1 to April 1 in the property time zone. Finally, they note a small off-by-cents error from summing binary floats in the API and recommend using decimal with half-up rounding and returning formatted strings.