2 Replies Latest reply on Nov 13, 2018 10:54 AM by Jim Dehner

    True option in filter not showing

    Garima Vohra

      Hello,

       

      I am struggling with this calculation.  I want to filter the values on True but as I drag my calculated field to filters shelf I see only 'False' , True is not there as an option?

       

      INDEX()= TOTAL(Count[Field])*0.25

      OR  INDEX()= TOTAL(Count[Field)*0.50

      OR  INDEX()= TOTAL(Count[Field])*0.75

       

      Any clues/suggestions why it is doing that

       

      Thanks,

      Garima

        • 1. Re: True option in filter not showing
          Ombir Rathee

          You need to change the table calculation by Compute using desired field. Can't exactly say without looking at your workbook.

           

          Right click on this field on filter shelf and compute using Field name you're using in your view as Addressing field. Then again edit the filter to select True values.

           

          Hope this helps.

          • 2. Re: True option in filter not showing
            Jim Dehner

            Good morning

            Would need to see the viz - you need to have something in the viz (i.e. field) to count

             

            rewrote your formula

            and it returned this

             

            Jim

            If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution.  Thank you.