{"type":"video","version":"1.0","html":"<iframe src=\"https://www.loom.com/embed/aa68b686cdf74e309b7d0a658f584a61\" frameborder=\"0\" width=\"1920\" height=\"1440\" webkitallowfullscreen mozallowfullscreen allowfullscreen></iframe>","height":1440,"width":1920,"provider_name":"Loom","provider_url":"https://www.loom.com","thumbnail_height":1440,"thumbnail_width":1920,"thumbnail_url":"https://cdn.loom.com/sessions/thumbnails/aa68b686cdf74e309b7d0a658f584a61-a040784c623f3de0.gif","duration":784.315,"title":"Adapting existing dashboards to use dedicated on-the-books measures ","description":"This walkthrough shows how to consolidate Forecasts & Budgets vs. OnTheBooks dashboard tiles using the new dedicated OnTheBooks measures in the Forecasts and Budgets topic. Instead of using two separate tabs with XLOOKUPs to join the data, you can now build a single, cleaner tile — with the only remaining XLOOKUP needed for Pickup data. The video covers rebuilding the tile, validating results against the original, cleaning up redundant filters and hidden tabs, and publishing."}