5 Replies Latest reply on Aug 15, 2016 9:13 PM by Mahfooj Khan

# Box Plot - How can i show the Whiskers/Values as Text Box

Hey All - Will appreciate if someone can help me with this...

I would like to show the Box Plot values (Whisker values) in the dashboard that i am creating.

Similar to what i have in the 2nd image below. I had to manually type these values and i am looking for a automated way to do this (if possible)  • ###### 1. Re: Box Plot - How can i show the Whiskers/Values as Text Box

I don't know how much this help you. But you can try this. Add summary in your worksheet you can get the info. But initially you'll get for entire graph. For individual you've to select. See the screen shot I've selected 2014.

Just right click and add summary in your worksheet You can add more marks from summary from drop down. • ###### 2. Re: Box Plot - How can i show the Whiskers/Values as Text Box

You can create calculated field for each of the values. Then put them in a

text box or a table.

percentile(variable, 1) =Max, upper whisker

percentile(variable, 0.75)=3rd quartile

percentile(variable, 0.50)=median

percentile(variable, 0.25)=first quartile

percentile(variable, 0)=Min, lower whisker

Note that the definition of whiskers could be different. Just create a

formula for it.

On Tue, Aug 9, 2016 at 10:21 AM, Mahfooj Khan <tableaucommunity@tableau.com>

• ###### 3. Re: Box Plot - How can i show the Whiskers/Values as Text Box

Thanks Mahfooj...i tried this earlier but Summary option only gives me the Count and not showing any of the other index's.

Btw, do you know the math behind Tableau's Box Plot calculations? I think it's different than the traditional box plot calc, am i right?

Will appreciate if you can help me understand the math used by Tableau

• ###### 4. Re: Box Plot - How can i show the Whiskers/Values as Text Box

Btw, do you know the math behind Tableau's Box Plot calculations? I think it's different than the traditional box plot calc, am i right?

Will appreciate if you can help me understand the math used by Tableau

• ###### 5. Re: Box Plot - How can i show the Whiskers/Values as Text Box

I think below mentioned links can help you to get the idea how box and whisker plot works