-
1. Re: tooltip: how to display it when hoovering over the label (and the data)
Matt LuttonAug 5, 2013 8:32 AM (in response to Jorge Villacampa)
I'm not sure if this is possible, but I agree it would help. You should be able to select a header like "CAD" and get summary information for the bar once it is selected. I know its not what you want, but it may be the only option. Other forum members may know more--I am not an expert.
-
2. Re: tooltip: how to display it when hoovering over the label (and the data)
Jorge Villacampa Aug 6, 2013 6:38 AM (in response to Jorge Villacampa)Hello Matthew/Johan,
Thanks for your replies. I raised this Tableau support to see if this is possible and if not, I raised as "Idea"
Thanks again for your responses
Regards
Jorge
-
3. Re: tooltip: how to display it when hoovering over the label (and the data)
Jim Wahl Aug 6, 2013 7:01 AM (in response to Jorge Villacampa)You might try a small hack, which is to add another invisible mark on a dual axis.
For example, in the below, I created a calculated field Tooltip Select =
IF [Gross Profit Ratio] < 0
THEN WINDOW_MIN([Gross Profit Ratio])
ELSE WINDOW_MAX([Gross Profit Ratio])
END
Then I added this to the view and used dual measure. In the marks window for Tool Tip Select, I select color > transparency = 0%.
You can remove this field from the tool tip, but whenever you "land" on the invisible area, the tooltip will show with, in my example, the Gross Profit Ratio.
See attached.
Jim
-
tooltiphack.twbx.zip 1.5 MB
-
-
4. Re: tooltip: how to display it when hoovering over the label (and the data)
Andy Piper Aug 6, 2013 8:03 AM (in response to Jim Wahl)Nice trick to extend the tooltip information to the end of the longest positive/negative bar.
-
5. Re: tooltip: how to display it when hoovering over the label (and the data)
Andy Piper Aug 6, 2013 8:13 AM (in response to Jorge Villacampa)Jorge,
If you don't mind the width of your bar label being the same width as your bar chart, then look at the "Using Index" tab of the attached workbook (which came from Jim Wahl's earlier example). Here I take advantage of the dual axis feature, calculated fields with the Index function, shapes that are white with sizes that are too small to be noticeable, a fixed table axis, and reformatting the axis font colors so they too are white -- if white is not your background color, set the color accordingly.
Hope this helps,
Andy-
tooltiphack2.twbx.zip 1.5 MB
-
-
6. Re: tooltip: how to display it when hoovering over the label (and the data)
Jim Wahl Aug 6, 2013 8:37 AM (in response to Andy Piper)I like it!
Do you need to use INDEX() or can you just set it to 1, add the measure as a MIN aggregation type, and then set the axis to go from 0 to 100?
-
7. Re: tooltip: how to display it when hoovering over the label (and the data)
Andy Piper Aug 6, 2013 9:19 AM (in response to Jim Wahl)Jim,
I'm sure you can use another formula besides index. Because the location where the text (label in our case) displays is the location of the mark on the chart, I needed a way to make the number really small (so I used Index *.001) and then set a fixed axis much larger. This gives the impression that the text (label) for each bar starts left justified, when in fact none of the text is lined up with the text from any other row.
Andy
-
8. Re: tooltip: how to display it when hoovering over the label (and the data)
Jorge Villacampa Aug 7, 2013 5:13 AM (in response to Jorge Villacampa)Hello Jim/Andy,
Many thanks for tips! I will try to implement them today in my dashboard.
Thanks
Regards
Jorge