For this you might need to create a calculation and place that in the tooltip window that will be in the marks.
The calculation would be:
IF (Measure) = 1 Then 'YES'
Let me know if it works for you.
Hi Sandeep, thank you very much for the answer.
I've figured that it will be something like this. My problem is what the "(Measure)" shall be. The only measures in the sheet are the authors who are cited (the columns). Do I have to create a separate calculated field for each one of them?
Could you please attach a workbook or example data set or a screen shoot of the worksheet.
Can you save it as a .twbx and repost it please ?
Thanks for the answer.
I'm not sure that this will help. I don't want to change the name of the values (in the final version I will replace them with actual names). What I need is that when I hover over a cell that has the value 1, the tooltip will say "Yes", and when I hover a cell whose value is 0, the tooltip will say "No." And I would really like to be able to add or change rows or columns to this table.
No worries, do the same technique but first duplicate each data element that you want a different tooltip for, then change the alias on the duplicated data and put that on the tooltip, and use the original in your view.
There's probably more elegant methods of doing this, I would probably just write a calculated field but I think the work effort would be around the same.
This may not be feasible for your true dataset,
but just wanted to mention an additional method
which is pivoting your data:
Then you would be able to use a calculated field of
IF [Pivot Field Values]=1 THEN "Yes"
You would also be able to retain your sort by using
sort descending by field [Pivot Field Values] | SUM
This method may not work out for you seeing as how
you are wanting to add new columns as time goes by,
which will necessitate adding them to the pivot.
But I guess that will depend on how often you are updating
Please see workbook v10.5 attached in the forum thread.
276921art.twbx 48.7 KB
Thank you very much. It worked perfectly. I don't need to update the dataset too often, so it's not that much worry. And it looks really good.
Sandeep and Peter, thank you too. Your solutions may have been less adequate for this specific problem, but thanks to them I have learned a new thing in Tableau. And I really appreciate your willingness to help.
You guys rock
I'm glad that was helpful.
You may already be too far down the road for this,
but you could consider altering the structure of your data to be in tall format:
and then you with new articles, you could just add new rows
and wouldn't have to have to change the Workbook or add anything to the Pivot.