Skip to content
Advertisement

count of nulls over a window

I need to get the count of nulls group by ID but excluding the month and sales in group by

sample data

what i need as a output

As you can see i have multiple years and i need the partition on id and year NOT MONTH

Advertisement

Answer

Using a case expression in count window function.

User contributions licensed under: CC BY-SA
1 People found this is helpful
Advertisement