{"type":"video","version":"1.0","html":"<iframe src=\"https://www.loom.com/embed/513c9b6d1d5e4ac38d0f8d66b247f4d6\" 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/513c9b6d1d5e4ac38d0f8d66b247f4d6-f1123d2678569ad5.gif","duration":261.385,"title":"Custom Lead Times Dimension","description":"In this video, I walk through how to customise lead time buckets within the Forecast Evolution topic. Starting from the existing 90, 60, and 30-day categorisation, I show how to add a new 45-day bucket using a formula generated with natural language. I then explain how to convert that workbook formula into a reusable dimension by saving it to the workbook, allowing it to be used safely across analyses without dependency errors. Finally, I demonstrate how the new custom lead time can be used to categorise units and highlight how the same approach can be applied to other dimensions."}