2 Replies Latest reply on Aug 29, 2018 4:30 AM by Mahfooj Khan

    Aggregate Measure Not Displaying

    Jinjia Lin
      Team
      Number of Females
      Female-Total Percentage
      Total Team Size
      Team A2350%46
      Team B00%<TOTAL TEAM SIZE NOT SHOWING HERE>
      Team C1520%

      75

       

      Hi,

       

      I have the following table on Tableau. The actual table consists of many more of such cases: when the <number of Female> count is 0, the total team size count is not showing. It is not 0, so idk how ZN/IFNULL would work in this case (or does it even work in this case because the team size is not even supposed to be 0?). TLDR: when I have 0 count for the percentage, the total team size always does not show.

       

      The total team size is taken from a dataset where each individual is identified by a distinct ID and Team, Gender.

      The calculated field for Total Team Size is {fixed [Team]: count([ID]).

       

      Appreciate any form of guidance, thank you!

        • 1. Re: Aggregate Measure Not Displaying
          Naveen B

          Hi Jinjia,

           

          Your calculations looks good,

           

          Is there any filters affecting the sheet then add them to context because as per tableau Order of Operations Dimension filters works after fixed calcualtions

           

          If this solution didn't resolve the problem kindly attach the workbook some sample data so that it will be easy to decipher the problem

           

          Tableau Forum Guidelines

           

          BR,

          NB

          • 2. Re: Aggregate Measure Not Displaying
            Mahfooj Khan

            Hi,

             

            Quick question:

            [Number of Females] and [Female-Total %] are calculated fields? If so then have you used ZN() / IFNULL() to handle the NULL as zero.

            Then handle the NULL for the same in [Total Team Size] calculated field and check. Else check the underlying data for Team B

             

            Or

            As Naveen has mentioned share some sample mock up data.

             

            Mahfooj