2025 Nov. FOCUS Friday: Mastering Group Cal, How to Build Seamless Drilldowns & FOCLOG Reporting

Grab your favorite cozy sweater and a mug of cider, because it's time to Fall Into Modern Reporting with our upcoming FOCUS Friday webinar! We've packed this session with powerful tools and essential insights to help you clean up your code, make your reports more intuitive, and see exactly how FOCUS is being used across your company. Think of it as raking away the old leaves (legacy syntax!) to reveal fresh ground underneath. Join us as Walter Brengel and special guest Kin Lim discuss: Mastering Group Calculations: Modernizing LAST and WITHIN with PARTITION Functions Are you still relying on legacy syntax for complex group-wise calculations? Join us for an essential session where we introduce and master the powerful, flexible family of window functions: PARTITION_AGGR and PARTITION_REF. These modern tools provide better control over sort breaks and are a replacement for several older commands (LAST, WITHIN). We will explore how these functions allow you to define explicit groups and frames for all your computations. Designer Navigation: How to Build Seamless Drilldowns Join this session to learn how to implement advanced drilling capabilities on your Designer Pages. We'll focus on the portalDispatch JavaScript function for target chart/report navigation within a specific container, and also demonstrate the function used to drill to a specific Designer Page within a Designer Portal. FOCLOG Reporting You turned on the FOCLOG data capturing, now what? Join us as we show the various types of reports that can be run to see how the ibi FOCUS product is being used at your company. A review of the menus and various reports will be highlighted.