4 Replies Latest reply on Aug 1, 2018 4:58 AM by Ayush Jain

    Using a Calculated Field in formula in Sets

    Ayush Jain

      Hi,

       

      I am trying to use a formula while creating sets but this is throwing me an error

      I am trying to find Top 10 using the below formula

       

      COUNT(IF [Month] = "June" THEN [Delivered] END)

       

      Here Delivered is a Calculated Field

      Error coming is - The field has an Invalid Filter

      Below is the screenshot.

       

      Can someone help me on this

       

        • 1. Re: Using a Calculated Field in formula in Sets
          Ritesh Bisht

          Hi Ayush,

           

          Hope it helps !

          Issue

          After replacing a data source, then a user filter set may become invalid with a red ! mark and the error "The Field... has an invalid filter" occurs.

          Environment

          • Tableau Desktop
          • User Filters

          Resolution

          Option 1:

          If there is an old version of the workbook with a valid user filter, follow these steps:

          1. In the new workbook, change the name of the field that the user filter was built on back to its original name
          2. Copy the functioning user filter in the old workbook
          3. Paste the function user filter into the new workbook
          4. Change the name of the field back to the desired name

          Option 2:

          Rebuild the user filter set

          Cause

          The field used to create the user filter has been given a new name, causing an invalid reference in the user filter set.

           

           

          Thanks,

          Ritesh

          Please mark the post as CORRECT & HELPFUL if it really helped you so that it can help others as well

           

           

          • 2. Re: Using a Calculated Field in formula in Sets
            Ayush Jain

            Hi Ritesh,

             

            Thank you for replying but this is not working.

            I have tried to rebuilt the Set many times but still the same error

             

            This has something to do with calculated field. If I am using some field within data source, then only it is working

             

            Regards

            Ayush

            • 3. Re: Using a Calculated Field in formula in Sets
              Ayush Jain

              Hi Ritesh,

               

              Basically I want to find top 10 people based on DELIVERED in JUNE (Please see below screenshot)

              Can you please tell me how can I do that