1 2 Previous Next 16 Replies Latest reply on Mar 8, 2018 8:05 AM by Aditya Singh Go to original post
      • 15. Re: How to extract value / data from Measures?
        Vikas Agrawal

        Hello All,

         

        I got the solution as below -

         

        1. Good Call

        IF [Call Quality] = '"Good"' THEN [Number of Records] ELSE NULL END

        ---------------------------------------------------------------------------------------------

         

        2. Poor Call

        IF [Call Quality] = '"Bad"' THEN [Number of Records] ELSE NULL END

        ---------------------------------------------------------------------------------------------

         

        3. Good to Poor Ratio

        SUM([Good Call]) / SUM([Poor Call])

         

        Actually earlier solutions were correct but I have missed double inverted comma ( " ) which was the part of data itself and which in turn lead to failure as it was not tableau was not reading it as I was expecting.

         

        But now, i have appended one more single inverted comma to Good and Bad as '"Good"' and '"Bad"' which gave me the solution I was expecting.

         

        Thank you all for help.

         

        Best Regards,

        Vikas

        • 16. Re: How to extract value / data from Measures?
          Aditya Singh

          Good to know that your issue resolved!

          1 2 Previous Next