
1. Re: Measure Names for String in Measures
sudheer.kumar.5 Jun 19, 2018 9:38 PM (in response to Adhitya Sanusi)
Measure Names_v10.2.twbx 17.4 KB


2. Re: Measure Names for String in Measures
Adhitya Sanusi Jun 19, 2018 9:42 PM (in response to sudheer.kumar.5)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 Jun 19, 2018 9:55 PM (in response to Adhitya Sanusi)2 of 2 people found this helpfulHello 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

4. Re: Measure Names for String in Measures
Mahfooj Khan Jun 19, 2018 10:02 PM (in response to Adhitya Sanusi)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 Jun 20, 2018 12:03 AM (in response to 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 Jun 20, 2018 12:18 AM (in response to Adhitya Sanusi)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 Jun 20, 2018 12:20 AM (in response to Adhitya Sanusi)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