7 Replies Latest reply on Jun 20, 2018 12:20 AM by sudheer.kumar.5

    Measure Names for String in Measures

    Adhitya Sanusi

      Hi All,

       

      How do you show the measure names for any string that are placed in Measures? Below is the screen shot. I would like 'No Measure Value' to be replaced with 'Complain Rating' and 'Number of Advisers' words. Attached is also the Tableau file for your perusal.

      Thank you all for your help.

       

      Kind regards,

       

      Adhi

        • 1. Re: Measure Names for String in Measures
          sudheer.kumar.5

          Hello Adhitya,

           

          Does this help?

           

           

          Attaching the .TWBX file.

           

          S

          • 2. Re: Measure Names for String in Measures
            Adhitya Sanusi

            Hi Kumar,

             

            thank you for your help. Unfortunately I'm not be able to see the attachment since I'm using Tableau 10.0.13.

             

            Could you please kindly explain what you did for the report?

             

            Thank you. Really appreciate it.

             

            Kind regards,

             

            Adhi

            • 3. Re: Measure Names for String in Measures
              sudheer.kumar.5

              Hello Adhitya,

               

              Step1:

              I have modified the calculations as below:

               

              Complain Rating:

              if ([Number of Distinct Complain]) >=2 then '1'

              elseif ([Number of Distinct Complain]) = 1 then '0'

              END

               

              Number of Advisers:

              if [Number of Distinct Advisers] > 7 then '1'

              else '0'

              end

               

              Step2:

              After that, I have changed the number format to Number.

               

              Step3:

              Place Measure Values to Text.

               

              Step4:

              Right click on Measure Names in Row shelf and select Show Filter. Select Complain Rating and Number of Advisers.

               

              Hope this helps.

               

              S

              2 of 2 people found this helpful
              • 4. Re: Measure Names for String in Measures
                Mahfooj Khan

                Hi,

                 

                Measure names will be show once your drag the Measures Value on your marks.

                You calculated fields are evaluating string values so it will only create headers though its in measures pane but it doesn't mean they are measure. Is there any specific reason to use measure names

                How about this?

                Or you need to convert your calculated field like this to evaluate numbers

                0=High and 1=Low

                 

                Modify your both the fields

                Complain Rating

                if ([Number of Distinct Complain]) >=2 then 0 //High

                elseif ([Number of Distinct Complain]) = 1 then 1  //Low

                END

                 

                Number of Advisers

                if [Number of Distinct Advisers] > 7 then 0

                else 1

                end

                 

                Then Measure drag measure name on filters shelf and select only Complain Rating & Number of Advisers from the list.

                Now drag the measure values on label to generate the headers. See the screenshot

                 

                Let us know if this help.

                 

                Mahfooj

                • 5. Re: Measure Names for String in Measures
                  Adhitya Sanusi

                  Thank you very much Kumar, Mahfooj for your time to view my report.

                   

                  So technically it is impossible to show the measure name when the measure values are strings, unless I convert the 'High' and 'Low' to numbers '1' and '0'. Then drag the measure values into text marks and drag measure name into rows.

                   

                  I guess I need to use the numbers and create the legend as a work around, or like you mention above Mahfooj, create the 'normalise' table style where each calculated fields become the headers.

                   

                  Once again, thank you very much guys for helping me with this. I really appreciate it.

                   

                  Kind regards,

                   

                  Adhi

                  • 6. Re: Measure Names for String in Measures
                    Mahfooj Khan

                    I would suggest use normalized table. If you get the answer than kindly close the thread by marking the most deserving answer as correct so that this post gets hide from the unanswered list.

                     

                    Let us know if you still have any doubts

                     

                    Mahfooj

                    • 7. Re: Measure Names for String in Measures
                      sudheer.kumar.5

                      Hello Adhitya,

                       

                      Yes, if you want to show the measure numbers it is not possible with the string data type. We need to have the numbers to plot as measure values. Hope it is clear now.

                       

                      Happy Tableauing

                       

                      S