3 Replies Latest reply on Oct 20, 2018 10:17 AM by Don Wise

# Create Multiple lines in a graph (Low quartile, median, upper quartile, max)

Hi all,

I am new to tableau and would really hope that someone will be able to help in this problem. I have been amazed by the helpfulness and friendliness this community is as well as the speed at which the community comes forth in solving problems. I believe this forum will be able to aid in solving my problem !

I have been surfing around the forums for the past two weeks and am unable to seek a solution to this problem. It is for my work and my personal desktop does not have tableau so i apologise for the convenience but I am really in need of help! I have an excel file which consists of dummy data, which I have uploaded here. I intend to use this excel file data to create a graph in tableau. I have created this graph in excel (Shown in the picture below) and hope tableau could do that too!

basically I have 2 Columns of data. The first column consists of dates and time in August, while the second column consists of numbers (Number of runs). I hope to use these two columns of data to create a chart which have 4 lines (Low quartile, median, upper quartile and max) with X axis as the time (Consisting of 24 data, from 12am to 12pm) and Y axis as the number of runs.

Much appreciate anyone's help! Thanks!

Best Regards,
Marcus

• ###### 1. Re: Create Multiple lines in a graph (Low quartile, median, upper quartile, max)

Hi Marcus,

Not sure how you're calculating upper/lower quartile in Excel, but my approach would be to evaluate what is the .25 percentile (lower quartile) and .75 percentile (upper quartile) and the pick the maximum of that as the Upper Quartile and the minimum of that as the Lower Quartile.  The Max and Median are easy enough to do in Tableau.  Please see attached 2018.2 workbook and below screenshot. I'm assuming this is for ambulance or fire department runs? With a larger set of data you'll probably see more variation with the upper/lower quartiles.  Thx, Don

Another more solid method would be to do a box-plot, which gets you the same information, more condensed but easier to see the outliers:

• ###### 2. Re: Create Multiple lines in a graph (Low quartile, median, upper quartile, max)

Hi Don,

Thanks for helping. However, I will require the 4 lines to be on the same axis. I managed to create a chart like yours in tableau with 4 different graphs and i have also managed to create a box and whiskers. However I am unable to put the 4 lines on the same axis which is required for my work. Thanks!

Best Regards,

Marcus

• ###### 3. Re: Create Multiple lines in a graph (Low quartile, median, upper quartile, max)

Hi Marcus,

No problem. Please see newly attached workbook and below screenshot: