{"type":"video","version":"1.0","html":"<iframe src=\"https://www.loom.com/embed/66c33e3c2d8a419e8771cbcdcdbf50c7\" frameborder=\"0\" width=\"3320\" height=\"2490\" webkitallowfullscreen mozallowfullscreen allowfullscreen></iframe>","height":2490,"width":3320,"provider_name":"Loom","provider_url":"https://www.loom.com","thumbnail_height":2490,"thumbnail_width":3320,"thumbnail_url":"https://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.eyJicyI6Imxvb20tbWVkaWEtY29udGVudCIsImF1ZCI6InRkcC1vcy1hcmNoZXR5cGUiLCJuYmYiOjE3OTQ2OTA3NzMsInRpIjoiNGMzYjM1MjItNGNmMi00ODRlLWExNmEtZTIyYTI1NmE4YmQ0IiwiYWRpIjoibG9vbS9sb29tIiwiaXNzIjoibWljcm9zLWdyb3VwL3RkcC1vcy1hcmNoZXR5cGUiLCJwaWQiOiI1NjQxMDkwMC0yMTg3LTRiN2EtOGE5Mi0wNWNhOTFmMWZkOTgiLCJ3YSI6ImZhbHNlIiwib2lkIjoic2Vzc2lvbnMtdGh1bWJuYWlscy02NmMzM2UzYzJkOGE0MTllODc3MWNiY2RjZGJmNTBjNy01ZGRkOTAxOGU2NzkxNGU0LmdpZiIsImV4cCI6MTc5NDY5MTM3MywiaWF0IjoxNzk0NjkwNzczLCJqdGkiOiJhNjg4MzIwNS04NzE1LTRiYWEtOTYxMy1mNGEyYTQ0NjNlMmUifQ.oX5akMNGFeQJIEfs6Gzig6YyCozmpyg0Z2_eM6Uwrlc5CX7lHiNLeuxx5rg97ETFdhe7HPHoHUlRdDtHqnEyIRCwh9K7ttnit6VOphwTdvxjDLoOGmX1lnOhs5Atdfzroe_Xkp0pucZYWa88wLP_iVjAXWBfvbgFjMGH2o5Ap6_zBNqk1Ta2obquVR4_dT8QOBn6lYX1KXVJ1pHGoj0UQrPAeI0r_M6E1q8_m8bG4IMDk8qCnWd0-fu-BBkUbPlJndFcpUpHs-L6R5HRemuW79gykyK7USLeF3L0F5QPDJg_WAoY0de23Cr2beC1V7zR1A_jNwTofvddkBsu5yazPw&Expires=1794691373&Signature=WNs87TytbQUOilcC1F4CjO%7E9Q7udgqjisKIPl934JtCq2aEY5fM5zD7Ny9qKamrHWjrX2JDI4cXjLf2u3Fu1z1BYwUWVDzqM3BDtddwFG7oj%7EALcUCCmGgCGkW8V6e2Jh8D2TBrj17GNJlDHEjIzjdO2m0YwGB2h2-dOGXDhwY94J8UKHiJLtfL1Uwkyn7trjDrn7Z7sNrNszVKNWle2uoe6CfcIz0eOxtN%7ECw2OI60B4uHhA%7EhvQcd0yaploPBlb6TSZXCPEoYQdqI64JwHexEL8PpRl3bi9ACE9J7lsh4HXzt%7EKBPCe3OiI02W7grArD6OpeT6xpNxqulT9tF5ow__&Key-Pair-Id=KQOSYIR44AIC0","duration":598.148,"title":"Fixing Multi Tenant Revenue Dashboard Issues","description":"This 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."}