2 Replies Latest reply on Feb 11, 2016 8:12 AM by Michael Hesser

# All Values and Multiple Percentiles on Same Chart

I've been reading up on some very similar posts (All Values and Percentile together ), as well as chatting with a few helpful folks, but I haven't quite grasped the solution to my problem.

I have a Gantt chart showcasing each "score" a customer receives.

I am also calculating several percentiles (an upper percentile, and a lower percentile).

Both are dynamically controlled through parameters

Resulting percentiles are rounded UP (in the case of upper percentile) or DOWN (for lower percentile).

How can I get these percentiles on the same chart as customer scores?

You might think adding reference lines would be the quick fix to this. Unfortunately, reference lines have the following snags for my viz:

Percentiles must represent integers where the lower percentile is rounded down & the upper percentile is rounded up. I don't think this is possible using reference lines.

The calculated percentiles need to be exportable when I View Data --> Export All.

I've attached a workbook with a mock-up of my graphs. Thank you for your help!

• ###### 1. Re: All Values and Multiple Percentiles on Same Chart

[Note: In the future please always mention the version of Tableau you are using especially if it isn't the latest one. Find 9.0 workbook attached.]

I did this with a dual axis chart. I reversed your Gantt and Circles, more common and readable. I also changed/simplified several of your calculations:

PercentileLower Floor

{ FIXED [Customer] : FLOOR(percentile([Score],[PercentileBandLower])) }

PercentileMedian

{ FIXED [Customer] : percentile([Score],.5) }

PercentileUpper Ceiling

{ FIXED [Customer] : CEILING(percentile([Score],[PercentileBandUpper])) }

--Shawn

2 of 2 people found this helpful
• ###### 2. Re: All Values and Multiple Percentiles on Same Chart

Beautiful work! Thank you Shawn.

3 of 3 people found this helpful