Activity overview
Latest activity by niketa
You can accomplish this by performing an OUTER JOIN with a table or dataset that includes all possible layers and titles. This guarantees that even if certain layers or titles are missing for a filtered business unit, they will still appear as empty rows in the result. Using COALESCE() allows you to replace missing values with placeholders. Additionally, applying GROUP BY with conditional aggregation helps maintain structure while filtering. If you're working with SQL Server, a CROSS JOIN with a predefined list of layers and titles can ensure consistency across different filters. / comments
You can accomplish this by performing an OUTER JOIN with a table or dataset that includes all possible layers and titles. This guarantees that even if certain layers or titles are missing for a fil...