3 Replies Latest reply on Feb 23, 2018 3:30 AM by Zhouyi Zhang

    Count null values for multiple dimensions

    Barbara Rabello Machado

      Hi!

       

      I need to create an analysis that will count how many fields I have with null values but the problem is that I need for different dimensions.

       

      For example, using the supersale I delete some values for city and state columns and I need to know how many rows are "Null" in each one of them.

       

      So far what I did was to create a calculation with: sum([number of records])-count([city]) and sum([number of records])-count([state]), the problem is that I need for multiple columns, and it would be very hard to make one calculation for each column.

       

      Anyone has any ideia how to make this in a easier way?

       

      Thank you,

      Barbara Rabello Machado