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!