1 Reply Latest reply on May 11, 2018 2:11 PM by Sam Epstein

    Calculation for Counting Values in Specific Excel Sheet

    Sam Epstein

      Hello Tableau Community,

       

      Simple question and sorry I'm still learning but whats the best way to create a calculated field that counts the number of records in a specific sheet. I'm trying to do that right now with this workbook to write a calculation that has the accurate 'Number of Records' for just the Feedback tab.

       

      Currently, the number of records is 209,000 (which is way off) so I  tried to create a calculation called Feedback Entries using:

       

      {FIXED [Store Name],[Date of Visit]

      : max([Number of Records])}

       

      But I return with 2891 instead of 3643. I attached the workbook as well as the excel sheet for reference.

       

      Would really appreciate some help on this and thank you!