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.
2 of 2 people found this helpful
I have modified the calculations as below:
if ([Number of Distinct Complain]) >=2 then '1'
elseif ([Number of Distinct Complain]) = 1 then '0'
Number of Advisers:
if [Number of Distinct Advisers] > 7 then '1'
After that, I have changed the number format to Number.
Place Measure Values to Text.
Right click on Measure Names in Row shelf and select Show Filter. Select Complain Rating and Number of Advisers.
Hope this helps.
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
if ([Number of Distinct Complain]) >=2 then 0 //High
elseif ([Number of Distinct Complain]) = 1 then 1 //Low
Number of Advisers
if [Number of Distinct Advisers] > 7 then 0
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.
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.
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
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.