3 Replies Latest reply on Nov 2, 2016 9:29 PM by Rudranshu Praharaj

    # of records?

    Vishal D

      How do I calculate the # of records of underlying data and not the aggregated data which I am showing in widget

       

       

        • 1. Re: # of records?
          Matt Lutton

          {FIXED: SUM([Number of Records]} will always return the underlying total # of records -- otherwise, the measure is aggregated to the level of the dimensions in your view/worksheet. Its an LOD expression: Top 15 LOD Expressions | Tableau Software

           

          You could alternatively just build a second sheet with SUM(Number of Records) on Text by itself, and that would give you the total # of underlying records as well.

          2 of 2 people found this helpful
          • 2. Re: # of records?
            Vishal D

            Matt, for some reason the Fixed logic is also not working.

            I attached the twbx, on tool tip of pie chart I want to show count of # of underlying records.

             

            For e.g - Quality - there are 6 records and count should be 6 but I am getting only 1

             

            • 3. Re: # of records?
              Rudranshu Praharaj

              Hi Vishal,

               

              I am having trouble connecting to data in the given Tableau workbook.

               

              But I would suggest using the LOD expression something like this { Fixed [Least_granule_dimension]:[sum ( Number of Records)]} .

               

              Try and fix the LOD with the least granule dimension available, see if that works.

               

              Also could you attach another sample file for me to take a look, if this does not work.