I know there are lots of posts about this, but I am still struggling. I have a simple box plot and there are several instances of multiple institutions having the same value. I would like all the institutions to show up in the tooltip when the user hovers over the data point. For example, "R University" and "I University" both have the same data value of 11.0, but only one shows up in the tooltip. What is the most straightforward way for a beginner to get both institutions to appear in the tooltip? Thank you!
PS: Is there a way yet to remove the automatic quartile and whisker info? My audience will not need this info. I am using 9.3.0
Yes, very different. What you'll essentially be doing is using a unique rank to offset each of the institutions. The result looks like this:
You can adjust the range of the Rank axis to make the box/whisker chart overlap the filled circles.
To do this, I had to first use a LOD calculation to group up the institutions whose average of Measure 1 were the same. I added this calc to the Detail mark.
{ FIXED [Institution] : AVG([Measure 1]) }
Then, I used RANK_UNIQUE to create the artificial X-axis you see above. Drop this calculation onto columns and compute along Institution.
RANK_UNIQUE(AVG([Measure 1]))
Voila! If this solution works for you, please mark it as correct so others can find it. Thanks!
