13 Replies Latest reply on Mar 13, 2015 12:43 PM by Shine Pulikathara

# Show Range of Values Rather Than Individual Values?

Here is a question I got a while back. I thought I would share with the community.  See below. This is a chart that shows the math, verbal and writing scores for every student in three schools. But there are occasions where we do not want to expose every student's name and score due to confidentiality or other considerations. Are there alternative views that can show a range of scores rather than individual scores?

Workbook is attached.  I will post my own solutions in the next couple of days. At the meantime, I would love to hear your solutions. Come on in, and share your wisdom.

http://www.pinterest.com/pin/create/extension/

• ###### 1. Re: Show Range of Values Rather Than Individual Values?

Kind regards

• ###### 2. Re: Show Range of Values Rather Than Individual Values?

Hi Cyril,

Thanks for looking into this. The file I uploaded earlier is a 9.0 file, which might be the cause for opening problem.  Here you go.  This one is 8.3.  Let me know if this works.

Miranda

• ###### 3. Re: Show Range of Values Rather Than Individual Values?

I suggest Box Plots, using maximum extent of the data and hiding underlying marks (there are no outliers when you use "maximum extent of the data"). See attached.

1 of 1 people found this helpful
• ###### 4. Re: Show Range of Values Rather Than Individual Values?

It's working

Can you be more specific abut the kind of range you want  ? You don' want individual points ? You want a line ? Or is it just that you don't want to see the student info ?

Because if you just remove the student name from the tooltip you have individual notes, range and confidentiality

Thanks

• ###### 5. Re: Show Range of Values Rather Than Individual Values?

We can't use boxplot in this instance, because boxlot still keep all the individual values while adding reference lines on them. Are there alternative views that just show the max and min for each category? No individual values can be shown.

• ###### 6. Re: Show Range of Values Rather Than Individual Values?

I beg to differ - did you open the workbook? There are no individual values showing. Short of downloading the underlying data, which you can secure via Tableau Server, nobody can see the individual values.

• ###### 7. Re: Show Range of Values Rather Than Individual Values?

Sorry Bill. I was too quick in my reply on assumptions. Saw yours. And they are fantastic.  Better than the solution I am about to post.

I am posting your image just so it is more visible.  Awesome work!!

http://www.pinterest.com/pin/create/extension/

http://www.pinterest.com/pin/create/extension/

• ###### 8. Re: Show Range of Values Rather Than Individual Values?

Always happy to help!

• ###### 9. Re: Show Range of Values Rather Than Individual Values?

The below is not intended as correct answer, which already is provided by  Bill Lyons,  but rather to make awareness about another method which I saw  Shine Pulikathara  use in  How to create gantt chart without date dimension?

Here is my adaptation of it:

Math MIN

`WINDOW_MIN(AVG(Math))`

Math MAX-MIN

`WINDOW_MAX(AVG(Math)) - WINDOW_MIN(AVG(Math))`

It still contains 1 student in view data

Workbook Version:  9.0

.

• ###### 10. Re: Show Range of Values Rather Than Individual Values?

Bill's solution is much better and easier than mine. But I want to post mine any way just so that you see the alternatives.

I did a gantt chart first, but not happy with it because I can't effectively show the labels.

I also did a dot chart and gantt chat combination, but this one is way complicated.

Workbook is attached for reference.  And thanks to Bill who came up with a much better solution.

http://www.pinterest.com/pin/create/extension/

http://www.pinterest.com/pin/create/extension/

1 of 1 people found this helpful
• ###### 11. Re: Show Range of Values Rather Than Individual Values?

Hi kettan, seems like we shared some common thoughts there.

• ###### 12. Re: Show Range of Values Rather Than Individual Values?

• ###### 13. Re: Show Range of Values Rather Than Individual Values?

Thanks for the mention kettan. Great to see similar concepts being applied across multiple contexts.